Thursday, July 9, 2009

Column Values to Comma Separated Values

SELECT STUFF((SELECT ',' + [FirstName] FROM Employee
WHERE RowjunctionID = 18 FOR XML PATH('')),1, 1, '') AS Column2CSVString

No comments:

Post a Comment