13
Jan
2023
2023
Multiple rows to one comma separated value in Sql Server
by Shubham Batra
48
Multiple rows to one comma-separated value in SQL Server
DECLARE @Table1 TABLE(ID INT, Value INT) INSERT INTO @Table1 VALUES (1,100),(1,200),(2,300),(2,400) SELECT ID ,STUFF((SELECT ', ' + CAST(Value AS VARCHAR(10)) [text()] FROM @Table1 WHERE ID = t.ID FOR XML PATH(''), TYPE) .value('.','NVARCHAR(MAX)'),1,2,' ') List_Output FROM @Table1 t GROUP BY ID
Here is the output for Multiple rows to one comma-separated value in SQL Server