How to concatenate text from multiple rows into a single text string in SQL server?

SQL

STUFF((SELECT ', '+ Column1 FROM Table1 FOR XML PATH('')),1,1,'') AS ConcatenatedColumn

StudentName
-------------
Mary
John
Sam
Alaina
Edward

Result: Mary, John, Sam, Alaina, Edward

How to get the first and last date of the current year in SQL

Post Views: 125