Blog Archives

Group by concat string of Column value in TSQL

how to get following query by using just single statement id Name Value 1 A 4 1 B 8 2 C 9 to id Column 1 A:4, B:8 2 C:9 and query isĀ  CREATE TABLE #YourTable ([ID] INT, [Name] CHAR(1),

Tagged with: , ,
Posted in SQL Server