sql for xml path

 

 

 

 

SELECT  r.Id, r.Name, (SELECT STUFF((SELECT ',' + v.SubName FROM Records v WHERE v.Id = r.Id FOR XML PATH('')), 1, 1, '')) AS SubNames
FROM    Records r ;