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
awking00
Can you guarantee an equal number of rows and columns to begin with?
ASKER CERTIFIED SOLUTION
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
SOLUTION
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
ASKER
That helped. thanks a lot