HomeОбразованиеRelated VideosMore From: Blake B

SQL Concatenate All Rows Into A String

12 ratings | 4091 views
Combine all rows into a single string adventure works example. This method uses coalesce to remove the leading comma. Easier than for xml path in my opinion. For XML path example(next video): https://www.youtube.com/watch?v=QwPjbQosjgw
Html code for embedding videos on your blog
Text Comments (5)
Sultan Ali (14 days ago)
hi how can i combine data from two different tables. I want to show two columns Person name & products. And the result should appear as e.g Ali Shirt,Cap,shoes
DHARMYOG_COM (6 months ago)
this is great. I don't have to write a loop or cursor. thank yoou. much appreciate it
PhuongTDo (9 months ago)
Thank you so much, it helps me.
mulugeta kebede (11 months ago)
this is awesome. do you a website that i can go and look other videos ?
Rithu Thomson (1 year ago)
Thanks a lot

Would you like to comment?

Join YouTube for a free account, or sign in if you are already a member.