Shiju S
asked on
Transposing result of a select statement
Hi,
I would like to get transpose of a select statement result.
Is there a way to do this in SQL Server
I would like to get transpose of a select statement result.
Is there a way to do this in SQL Server
Col1 Col2 Col3
---- ---- ----
A B C
D E F
G H I
Transpose result
Col1 Col2 Col3
---- ---- ----
A D G
B E H
C F I
Can you guarantee an equal number of rows and columns to begin with?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
That helped. thanks a lot