From: TheSQLGuru on
In addition there is a massive and very helpful thread on
sqlservercentral.com about this topic too, with lots of code examples and
even benchmarking!

--
Kevin G. Boles
Indicium Resources, Inc.
SQL Server MVP
kgboles a earthlink dt net


"Plamen Ratchev" <Plamen(a)SQLStudio.com> wrote in message
news:a1bou592etg6hsmjq62eov6af0ovk98jgv(a)4ax.com...
> Here are different methods to handle that:
> http://www.projectdmx.com/tsql/rowconcatenate.aspx
>
> --
> Plamen Ratchev
> http://www.SQLStudio.com