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.
| Author |
Topic |
|
shotz1015
Starting Member
4 Posts |
 Posted - 2009-12-01 : 15:49:29
|
| I have a transaction, which in turn can have many line items of products. I want to write a query that returns the transaction date only once, than all the line items underneath it instead of having the transaction date repeat over and over for every line item. Ideally it would look like thisDate: Product 1 Product 2 Product 3 Product 4Instead of Date: Product 1Date: Product 2Date: Product 3Date: Product 4 |
|
|
DP978
Constraint Violating Yak Guru
269 Posts |
|
|
|
|
|
Help with group by