how to convert a single row into Column in SQL Server 2005
- by joy
Hi,
I have a table, and it is returning the data as -
Column1 Column2 Column3 Column4 Column5 Column6
-------------------------------------------------------------------
6 Joy Mycity NZ 123456 myemail@gamil.com
I need to disply it as -
SingleColumn
-----------------------
6
joy
mycity
NZ
123456
myemail@gmail.com
How do I do it?