The first result I get when searching for "unpivot" is called "Using PIVOT and UNPIVOT" - that looks very promising :-). If you meant something else, please be more specific, as these words can have various meanings.
Jeanne Boyarsky
,
author & internet detective
staff
In that case, the Microsoft Tech Note Ulf mentioned is a good start. Take a look and that post back what questions you have. Also, I'll move this to our database forum.
Post by:autobot
What's wrong? Where are you going? Stop! Read this tiny ad:
a bit of art, as a gift, that will fit in a stocking