| || |
Convert Multiple Rows into One Comma Separated Values in SQL server
Posted On: 13-May-2018 06:55
I have come across the problem converting multiple rows values to a comma separated values while doing development. Finally I have sorted this problem. So I have decided to write an blog on this.
I have following table 'Keyword'
Now I want to convert Keyword row values to one string value.
For the above problem, we can solve above problem with different queries.
Solution I): Using "COALESCE" function
Solution II): Using without "COALESCE" function
Solution III): Using "FOR XML PATH"
Active User (4)