Hi guys..
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......


thx before..

dede (neolempires2 (AT) gmail (DOT) com) writes:
Check out http://www.projectdmx.com/tsql/rowconcatenate.aspx for
suggestions.


--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx