Jeff Moden (6/10/2015)

---

David Burrows (6/10/2015)

---

Jeff Moden (6/9/2015)

---

Is the number of columns in the final output a given or do we have to have the code figure that out?

Shouldn't that be max number of rows per column1?

The use of 'FOR XML' may be the answer, there are several articles on this site will show you how, I think even Jeff may have published one:-D

*Edited*

And here it is http://www.sqlservercentral.com/articles/Test+Data/61572/

I was thinking that he actually wanted a CROSSTAB/PIVOT rather than a concatenation. 😀

Wow! That's an old article. I forgot I had that in there.