SELECT DISTINCT [col1], [col2], [col3] = STUFF ((SELECT ', ' + [col3] FROM tbl_abc b WHERE b.col1 = a.col1 FOR XML PATH('')), 1,2,'') FROM tbl_abc a
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)