Monthly Archives: March 2014

Crosstab Query (3)

DECLARE @Names VARCHAR(8000) SELECT @Names = COALESCE(@Names + ‘, ‘, ”) + Name FROM People SELECT @Names Or this post about FOR XML PATH http://stackoverflow.com/questions/194852/concatenate-many-rows-into-a-single-text-string Advertisements

Posted in SQL | Leave a comment