SQL Server - Concatenate rows into a string

[@killanasantoshbaba]

Awesome explanation. I like your step by step approach very much.
I have been searching for 2 hours to apply this logic into a complex query. But Now I am clear. Thanks a lot.

[@marshalljackson1385]

Excellent step by step explanation and demo. Very helpful. Thank you for this video.

[@joaquimcosta1101]

Very much educational...thanks.

[@user-zf2gz8je2g]

Very helpful!! Thank you!!😆

[@DharmYogi]

step 3 is slightly wrong. you have to cast the field as varchar then add the ',' else it wont work as it will append the ',' with the node.

[@learnanythingforfree2131]

Hello, i want to get this concatenation based on the value in another column. How do i do it?

[@jifacts5842]

Hi, can you give me an example of what you want to do? I can give you a much better answer if I have an example

[@annyusa5566]

Distinct is very expensive operation , it will degrade the performance. The same thing can be achieved with group by

[@superfreiheit1]

zoom in. Can see anything