Switching 1 row with few columns into 1 column with few rows in MS SQL SERVER

Posted by clint on Stack Overflow See other posts from Stack Overflow or by clint
Published on 2010-03-23T21:56:11Z Indexed on 2010/03/23 22:03 UTC
Read the original article Hit count: 259

Filed under:
|

hi, i've got 1 row with many columns:

col1|col2|col3|...

and i want to have 1 column with many rows, like that:

col1
col2
col3
..

© Stack Overflow or respective owner

Related posts about sql

Related posts about tsql