How to turn one column of a table into a csv string in SQL Server without using a cursor

August 12, 2023 by Tarik

STRING_AGG was added in sql 2017

https://learn.microsoft.com/en-us/sql/t-sql/functions/string-agg-transact-sql?view=sql-server-2017

SELECT STRING_AGG (ColumnName, ',') AS csv 
FROM TableName
GROUP BY ColumnName2