• Concatenate with FOR XML PATH.

    http://stackoverflow.com/questions/194852/concatenate-many-rows-into-a-single-text-string

    Catch-all queries done right [/url]
    Gail Shaw's Performance Blog[/url]