Comma delimited list, tsql

CREATE TABLE TEMPTABLE(

             [NAME] [varchar] (20),
             [GROUP] [varchar] (20)
             )
GO
INSERT INTO TEMPTABLE([NAME], [GROUP]) VALUES ('Address','Home')
INSERT INTO TEMPTABLE([NAME], [GROUP]) VALUES ('City','Home')
INSERT INTO TEMPTABLE([NAME], [GROUP]) VALUES ('Address','Work')
INSERT INTO TEMPTABLE([NAME], [GROUP]) VALUES ('City','Work')
GO

SELECT [NAME]
FROM TEMPTABLE

DROP TABLE TEMPTABLE

Select allOpen in new window

SELECT List = STUFF((
			SELECT DISTINCT ', ' + QUOTENAME([GROUP], '''')
			FROM (SELECT * FROM TEMPTABLE) x
			FOR XML PATH('')
				,TYPE
			).value('.', 'VARCHAR(8000)'), 1, 3, '')

Select allOpen in new window