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