Grant Fritchey (3/6/2009)
The one thing I'd suggest, instead of trying to pivot the data into columns, return it as rows, you'll have fewer joins and simpler queries that way. You can change the layout on the client side so that it's pivoted.
Can you explain this a little more? I am not following how I could pivot into columns instead of rows. What would my query look like?