How to concatenate text from multiple rows into a single text string in SQL server? – ErcanOPAK.com

SQL

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

- 19.04.19 | 22.11.19 - ErcanOPAK

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

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

Result: Mary, John, Sam, Alaina, Edward

Related posts:

Filter Rows By Max Date in SQL

Database stuck in “Restoring” state

Get the First and Last Word from a String or Sentence in SQL

Average of all values in a column that are not zero in SQL

Find numbers with more than two decimal places in SQL

Post Views: 121

Leave a Reply Cancel reply