Viewing 4 posts - 1 through 4 (of 4 total)
You can hard code as many joins as you like up to I think some maximum.
Practically speaking, depending on the number of fields displayed per line item, you'll run...
February 22, 2012 at 5:57 pm
#1450624
Here's some sample code that does what I was referring to earlier using full outer joins on the order id.
This transforms the data similarly to what you've displayed. It generates...
February 22, 2012 at 5:18 pm
#1450619
Quick way is to write a function that returns a string concatenating the line items and display as one column, whose header is "Line Item 1 , Line Item2, etc.".
The...
February 22, 2012 at 1:59 pm
#1450556
It's been over 6 months since the poll.
Anyone have the scoop on when 2008 R2 SP1 will be released?
February 8, 2011 at 3:24 pm
#1284103