Monthly Archives: March 2014

Crosstab Query (3)

Posted on March 11, 2014 by calvin998

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

Posted in SQL | Leave a comment