Joe_Fox type SQL question

[Matt_B]

I have a table of one row (it's actually a view, don't ask why I have a table with only one row)

Col 1, Col 2, Col 3, Col 4
12, 234, 25, 290

What I want to end up with, using SQL is

Col1, 12
Col2, 234
Col3, 25
Col4, 290

So turn 1 row into however many rows there are columns, with the single row value as the second column

I believe maybe cross join, cross apply or pivot tables may do this, but I can't for the life of me get it to work.

 

[Matt_B]

Once again as soon as I post it I find an answer, using UNION ALL.

Please close

 

[Darth Vodka]

PIVOT does it the other way round

there's an un-pivot transformation in SSIS...

 

[Matt_B]

I have 25 working days left until I never had to programme or touch SQL again, I can't wait.

 

[Darth Vodka]

oh there's actually an UNPIVOT in t sql

http://www.tsqltutorials.com/unpivot.php

well i never