Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: chopstix21
- Order by date
-
muenchian sum based on multiple grouping
I want to obtain a better xml file using some xslt and xml below. <?xml version="1.0" encoding="UTF-8"?> <Pallets><Pallet> <PalletNumber>2</PalletNumber> <Product>1</Product> <Quantity>2</Quantity> </Pallet> <Pallet> <PalletNumber>2</PalletNumber> <Product>1</Product>...- chopstix21
- Thread
- Replies: 1
- Forum: XML
-
concatenating column values in a row
i need to concatenate x values which are grouped by id, ordering them by y column from subquery. Subquery looks like this id x y 1 1 1 1 2 3 1 3 2 2 1 null 2 2 1 3 1 1 3 2 2 4 1 null 4 2 null final results should look like id result 1 1,3,2 2 2 3...- chopstix21
- Thread
- Replies: 2
- Forum: Microsoft SQL Server: Programming
