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

Is this possible?? Expand / Collapse
Author
Message
Posted Thursday, December 6, 2012 6:37 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Tuesday, April 2, 2013 3:25 AM
Points: 12, Visits: 42
I am getting a result set that looks like the following



wk no node QTY_done Qty_toDo Pcent

1 A 1 10 10

1 B 2 10 20

2 A 3 10 30

2 B 1 10 10



etc.....



I would like the data to appear like,

wk NodeA, AqtyDone, AqtyTodo, A Pcent, NodeB, BqtyDone, BqtyToDo, B Pcent

1 A 1 10 10 B 2 10 20





I have it working but using subqueries for each node, can a pivot query do this??? is thier a more efficent way or function?



thanks
Post #1393481
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse