Posted by Erland Sommarskog on 08/18/07 21:17

dede (neolempires2@gmail.com) writes:
> is there any query to do this action:
> i want to combine view record into a single record.
> exm.
>
> table 1
> Name A B
> Jack 10 22
> jack 12 21
> jack ... ....
> jack 1 11
> ben 12 2
> ben 3 2
> ben ... ...
>
>
> into:
> View 1
> Name combine
> jack 10,22 and 12,21and1,11 and .....
> ben 12,2 and 3,2 and......

Check out http://www.projectdmx.com/tsql/rowconcatenate.aspx for
suggestions.


--
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

[Back to original message]