An example to Concatenates Values of specified column Group By another column in SQL Server

FOR_XML_PATH.sql

--REFERENCE:http://stackoverflow.com/a/19348687

DECLARE @table TABLE(idx INT, name VARCHAR(10))
INSERT @table VALUES(0, 'hjwu01')
INSERT @table VALUES(0, 'hjwu02')
INSERT @table VALUES(0, 'hjwu03')
INSERT @table VALUES(1, 'hjwu11')
INSERT @table VALUES(1, 'hjwu12')
INSERT @table VALUES(2, 'hjwu21')
INSERT @table VALUES(2, 'hjwu22')

--want to show as follows
/*
	0, 'hjwu01,hjwu02,hjwu03'
	1, 'hjwu11,hjwu12'
	2, 'hjwu21,hjwu22'
*/

SELECT idx, STUFF
(
	(
        SELECT ',' + name 
        FROM @table tA 
        WHERE tA.idx = tB.idx FOR XML PATH('')
	), 1, 1, ''
) AS myname
FROM @table tB 
GROUP BY tB.idx