Display columns as rows

Question

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

SQLAssAS SSCertifiable Points: 7246 More actions · Answer 1

have a look at this

kapil_kk SSC-Insane Points: 21316 More actions · Answer 2

Use PIVOT

_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/

Mark Cowne One Orange Chip Points: 26952 More actions · Answer 3

Use CROSS APPLY

DECLARE @t TABLE(c1 INT, c2 INT, c3 INT, c4 INT)

INSERT INTO @t(c1,c2,c3,c4)

VALUES(2,4,6,5);

SELECT ca.column1,ca.column2

FROM @t

CROSS APPLY(VALUES('c1',c1),('c2',c2),('c3',c3),('c4',c4)) ca(column1,column2);

____________________________________________________

Deja View - The strange feeling that somewhere, sometime you've optimised this query before

How to get the best help on a forum