Multiple rows to one comma separated value in Sql Server
Hello guys and welcome to Code2Night. In the article, we will see how to convert Multiple Rows to a Comma-Separated Value in SQL Server
In SQL Server, there are times when we encounter scenarios where we need to combine multiple rows into a single comma-separated value. This can be useful when we want to retrieve data from a table in a format that is easier to process or display. Thankfully, SQL Server provides us with several techniques to achieve this.
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