help w/ pivot query

Question

hi all,  i'm trying to pivot the following table but can't seem to get it right.  Can someone help?

I have the following columns:

Geo-W | Geo-Y | Geo-R | Port-W | Port-Y | Port-G
0           1          0           0           0           0

I would like to pivot so that it look like this:

Geo-W | 0
Geo-Y  | 0
...
Port-G | 0
Total   | 1

Thanks.

Answer 1

select [Type], ColValue from myTable UNPIVOT (colValue FOR [Type] IN ([Geo-W],[Geo-Y],[Port-W],[Port-Y],[Port-G])) unpvt

---

For every expert, there is an equal and opposite expert. - Becker's Law


My blog

Answer 2

Hi Naomi,

that worked but how do I get the values assocated w/ those columns?

Answer 3

Sorry, I got distracted by new e-mails - I updated the query, I meant to post [Type],[ColValue] 

---

For every expert, there is an equal and opposite expert. - Becker's Law


My blog

Answer 4

thank you Naomi. all this time, i was trying to pivot instead of unpivot!