how to convert a single row into Column in SQL Server 2005

Posted by joy on Stack Overflow See other posts from Stack Overflow or by joy
Published on 2009-07-14T13:38:38Z Indexed on 2010/05/22 0:20 UTC
Read the original article Hit count: 500

Filed under:

Hi,

I have a table, and it is returning the data as -

Column1  Column2    Column3   Column4   Column5   Column6
-------------------------------------------------------------------
6        Joy        Mycity    NZ        123456    [email protected]

I need to disply it as -

SingleColumn
-----------------------
6
joy
mycity
NZ
123456
[email protected]

How do I do it?

© Stack Overflow or respective owner

Related posts about sql-server-2005