SQL Query | How to convert data from rows into comma separated single column | FOR XML PATH | STUFF

This video explains the SQL Query using FOR XML PATH and STUFF functions to convert data from rows into a comma separated column value.
You can check out the SQL Query here -
know-star.blog...
Please do not forget to like, subscribe and share.
For enrolling and enquiries, please contact us at
Website - knowstar.org/
Facebook - / knowstartrainings
Linkedin - www.linkedin.c...
Email - [e-mail]

[@anthonyjones9528]

Explained it so well that my baby Son could understand it. Thanks a million

[@jayjfreedman]

Great video, very good at explaining XML Path and STUFF separately.

[@LearnatKnowstar]

Glad it was helpful!

[@archananerkar3113]

after lots of search i got this video,that great thank you

[@LearnatKnowstar]

Thank you

[@mvicky9025]

Well explained thank you soo much for sharing.. 👍

[@LearnatKnowstar]

Thank you!

[@abdulk6311]

great video; Thank you! excellent explanation.

[@LearnatKnowstar]

Thank you

[@matts8911]

good explanations, thanks for sharing this video I found it very helpful.

[@LearnatKnowstar]

Glad it was helpful!

[@Melodychoice601]

Very nice logic used...👍

[@LearnatKnowstar]

Thank you!

[@viewableorchid6464]

Very easy to understand. Thank you

[@LearnatKnowstar]

Thank You

[@vishaljhaveri7565]

Awesome video explanation!

[@LearnatKnowstar]

Thank you!

[@niranjanbalajisingh6726]

Very useful stuff thank you

[@kristyowens2284]

Thank you for sharing!

[@LearnatKnowstar]

Thank you

[@Beyondhorizons-i5z]

Great session!

[@rajugrg2493]

Here, directly we can use strin_aggrigate() function

[@LearnatKnowstar]

You are correct. String_AGG function does not work for some older versions of SQL Server where this approach can be used.

[@kavipriya2823]

Can you please tell how to write stuff with different data types and columns for different tables?

[@FrankBadillo]

Thanks!

[@LearnatKnowstar]

You are our first Super Thanks! Thank you!!!

[@piyushjoshi8038]

I think Oracle LIST_AGG Function also works in same way, merging rows to comma separated values

[@LearnatKnowstar]

Yes, it is similar 👍

[@vaibhavware7164]

Yes ..its similar

[@elite_broly7590]

Good one 🙏

[@LearnatKnowstar]

Thank you !

[@briandennehy6380]

Another good video. Could I just suggest maybe formatting your code a bit better so that it's a bit easier to read and understand

[@LearnatKnowstar]

Thank you so much.

[@itaydiaz]

thank you

[@LearnatKnowstar]

Glad it was helpful

[@viewableorchid6464]

can we also use STRING_AGG function instead of this?

[@LearnatKnowstar]

Yes

[@landchennai8549]

declare @Table table (Id int,[Name] varchar(32))
insert into @Table values (1,'Prasad'),(1,'Priyan'),(2,'Askok'),(2,'Kumar')
select Id , STRING_AGG([Name],',') as Fullname
from @Table
group by Id

[@katesantos2343]

can this also be done from column to row? HELP ME PLESSS. THANK YOU 🥲

[@KiranPatil-zw8tm]

String_Agg would have been easy way to solve it.

[@LearnatKnowstar]

Yes. This is for SQL Server versions where STRING_AGG does not work.