Unpivot vs. Union queries in T-SQL 2008

Answer 1

after some headbanging, i figured out that an UNPIVOT is just like a where clause.. you can use as many as you need

SELECT Col1, Col2, Unp1, Unp2, Unp3
FROM TBL
UNPIVOT (XX For Unp1 (ColXX1, ColXX2))
UNPIVOT (YY For Unp2 (ColYY1, ColYY2))
UNPIVOT (ZZ For Unp2 (ColZZ1, ColZZ2))