Concatenate many rows into a single text string with grouping [duplicate]
try this -
SELECT DISTINCT fileid , STUFF(( SELECT N', ' + CAST([filename] AS VARCHAR(255)) FROM tblFile f2 WHERE f1.fileid = f2.fileid ---- string with grouping by fileid FOR XML PATH (''), TYPE), 1, 2, '') AS FileNameStringFROM tblFile f1