Partitioning

[ehenry]

I have a View That contains a list of 200 Points with a Measurement date and a Volume associated with that date.
I am selecting data for the past 5 days, but rather than having a table of 1000 rows i would like to have a 200 row table and 5 extra columns for each day. I was wondering if there was a way to partition or self join to make this happen? Any help would be appreciated.

 

[ousoonerjoe]

You should look into PIVOT tables.

MSDN: Using PIVOT and UNPIVOT

--------------------------------------------------
Bluto: What? Over? Did you say "over"? Nothing is over until we decide it is! Was it over when the Germans bombed Pearl Harbor? No!
Otter: Germans?
Boon: Forget it, he's rolling.
--------------------------------------------------