How to concatenate a field from multiple rows into a single text string in SQL Server?
|
SQL Buddy
2
Points
1
Posts
|
How to concatenate a field from multiple rows into a single text string in SQL Server? Consider a database table 'User' holding names, with three rows as:
I want query result as comma separated string as Peter,Paul,Mary
Views:
67
Total Answered: 1 Total Marked As Answer: 0 Posted On: 23-Jan-2023 22:57 Share: 
|
Answers
|
Rahul M...
1416
Points
238
Posts
|
Use FOR XML PATH clause as:
Posted On:
26-Jan-2023 05:29
|
