Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 summary

Author  Topic 

mkgmahi
Starting Member

24 Posts

Posted - 2012-01-12 : 07:31:59


orderno desc totalvalue

001 a 200
001 b 56


i need to display the above using the query in the below format
orderno desc totalvalue
001 a ,b 256

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2012-01-12 : 07:33:38
See examples of how to use XML to concatenate data.



N 56°04'39.26"
E 12°55'05.63"
Go to Top of Page
   

- Advertisement -