Dear all
I want to convert column to row in sql server.
this is my sample table
========================
ID Name Address
-- ---- -------
1 abc xxxxxx
2 pqr yyyyyy
3 lmn zzzzzz
4 xyz wwwwww
==========================
want result like this
----------------------------------------------------------------
ID 1 2 3 4
Name abc pqr lmn xyz
Address xxxxxx yyyyyy zzzzzz wwwwww
========================================
please help me.