SQL Query | How to convert data from rows into comma separated single column | FOR XML PATH | STUFF
HTML-код
- Опубликовано: 6 сен 2024
- 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 - learn@knowstar.org
Explained it so well that my baby Son could understand it. Thanks a million
Great video, very good at explaining XML Path and STUFF separately.
Glad it was helpful!
after lots of search i got this video,that great thank you
Thank you
Well explained thank you soo much for sharing.. 👍
Thank you!
good explanations, thanks for sharing this video I found it very helpful.
Glad it was helpful!
great video; Thank you! excellent explanation.
Thank you
Very nice logic used...👍
Thank you!
Very easy to understand. Thank you
Thank You
Here, directly we can use strin_aggrigate() function
You are correct. String_AGG function does not work for some older versions of SQL Server where this approach can be used.
Very useful stuff thank you
Awesome video explanation!
Thank you!
Thank you for sharing!
Thank you
Thanks!
You are our first Super Thanks! Thank you!!!
Great session!
Can you please tell how to write stuff with different data types and columns for different tables?
thank you
Glad it was helpful
I think Oracle LIST_AGG Function also works in same way, merging rows to comma separated values
Yes, it is similar 👍
Yes ..its similar
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
Thank you so much.
Good one 🙏
Thank you !
can we also use STRING_AGG function instead of this?
Yes
String_Agg would have been easy way to solve it.
Yes. This is for SQL Server versions where STRING_AGG does not work.
can this also be done from column to row? HELP ME PLESSS. THANK YOU 🥲