Posted by Erland Sommarskog on 07/17/07 21:49

rdraider (rdraider@sbcglobal.net) writes:
> Using SQL 2000, how can you combine multiple records into 1?
> The source data is varchar(255), the destination will be text. I need
> help with the select statement.

SQL Server MVP Anith Sen as a couple of methods on
http://www.projectdmx.com/tsql/rowconcatenate.aspx.


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

• Next in forum: Trigger After Delete - I need a Trigger Before Delete
• Prev in forum: Re: Logical Name
• Thread view: Re: Combining many records into 1

[Reply to this message]