SELECT Class,STUFF( ( SELECT ','+ Name FROM a b
WHERE b.Class = a.Class FOR XML PATH('')),1 ,1, '') Name
FROM a a GROUP BY Class
SELECT Class,STUFF( ( SELECT ','+ Name FROM a b
WHERE b.Class = a.Class FOR XML PATH('')),1 ,1, '') Name
FROM a a GROUP BY Class