Steve Jones - SSC Editor (10/13/2014)
Not sure. I wasn't sure how to frame this, but I've seen the concatenation question regularly, and sometimes with some aggregation or summary (like counting responses and listing them).Denormalize responses to a poll with T-SQL?
Summarizing and Displaying All Values in One Row?
Another way to Pivot data in T-SQL?
I'm open to suggestions.
K. I'll think of something. You're right... it is a common question. Wayne Sheffield's article on creating CSV's is a great one but I can see the need for something that will cover things like those in the URL you cited.
p.s. I can't speak for anyone else but it seems like the response time even just to view and article have gotten pretty slow. Clicking on "Quote" to respond to a thread seems to take a huge amount of time.
--Jeff Moden
Change is inevitable... Change for the better is not.