String_Agg() Function in SQL Server | how to get comma separated values in sql

[@rushiindra2968]

Hats 👑⛑👒🎩off to your explanations. Thanks

[@ssunitech6890]

Thanks a lot for your appreciation

[@Patiencelad]

Very clear explanation. Thank you!

[@ssunitech6890]

Thanks, Please share to others

[@sandhyasingh284]

Nice way to explain

[@ssunitech6890]

Thanks for your appreciation

[@sushanthbollaboina9392]

Hello sir, any chances of complete project explanation of sql server. How does it work in real world. Thank you!!

[@ssunitech6890]

Thanks 😊 This can be used in report sp. Where an invoice can have multiple payment methods and those need to display in single value. So it can be used to get comma separated values. Thanks

[@SharShaik]

on existing column how to insert delimiter eg: Full name 'Raviverma' output 'Ravi-verma' can pls provide solution

[@RaviKumar-pn8uw]

Sir...suppose Id 1 having CD CD CD 3 times how to make unique values in String Agg function output???

[@ssunitech6890]

Select id, string_agg with count rows

[@krishnapriya038]

Sir I have repeated names and I want only once, how to do that?

[@tusharjadhav6940]

Hello sir , i have one string (my|name|is|tushar|abc|ahha|haha|hshs) I already separated it using create function which is similar like string_split because i have old version of server, So sir , i have table which contains 8 columns col1,col2,col,3 I have to insert the seprated string values into this columns(8 columns are their) I am seprated it but they are form rows My Name Is Tushar Like that i need to insert into columns or horizontal way. Can you help me out???

[@ssunitech6890]

You can use the SSIS package or while loop in SQL

[@tusharjadhav6940]

@@ssunitech6890 sir can you please explain in briefly....or give logic how i will get output.

[@reneehambright7047]

Thank You!

[@ssunitech6890]

Thanks for your appreciation

[@naveenreddym6222]

How to get comma separated output as table

[@ssunitech6890]

Didn't get you, can u pls eloborate more

[@poonammahto6442]

THANKS

[@ssunitech6890]

Please Share to others

[@Mistysoil]

Its not working on my sql server verion 17.2

[@ssunitech6890]

It should not work, will check

[@shammi07462]

getting error string_agg does not exist

[@ssunitech6890]

Which version of SQL server?

[@landchennai8549]

please mentioned the server version also.

[@ssunitech6890]

Thanks for your suggestion..

[@supratikpaul6403]

It’s not working on MySQL

[@ssunitech6890]

This is for SQL server

[@supratikpaul6403]

@@ssunitech6890 can you please tell how to do it on mysql ?

[@RaviKumar-pn8uw]

​@@supratikpaul6403 listagg function use