Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Need help in Pivoting the table. Expand / Collapse
Author
Message
Posted Wednesday, May 1, 2013 9:01 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, December 16, 2014 7:52 AM
Points: 2, Visits: 29
Hi,

I need help on Pivoting a table. I have to do it in the back end only.
Here is the table that returns the data...

VS F1 F2 F3 F4 F5 F6 F7 F8
----------------------------------
V1 2 3 4 5 6 7 8 9
V2 2 3 4 5 6 7 8 9
V3 2 3 4 5 6 7 8 9

And I have to show this table in the below format. Can this be doable in sql server 2005?

VS V1 V2 V3
-----------------------------------
F1 2 2 2
F2 3 3 3
F3 4 4 4
F4 5 5 5
F5 6 6 6
F6 7 7 7
F7 8 8 8
F8 9 9 9
Post #1448454
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse