SQLTeam.com | Weblogs | Forums

Unpivot sql columns into rows


#1

I have a table with 8 columns

ALL,OPEN,CLOSED,RECOVERY,CLAIMS, PAYMENT1,PAYMENT2,PAYMENT3

I WOULD LIKE TO UNPIVOT THE COLUMNS INTO ROWS LIKE

ALL, PAYMENT1, PAYMENT2, PAYMENT3
OPEN
CLOSED
RECOVERY
CLAIMS