Is this possible??

• jasemilly

  Valued Member

  Points: 66

  More actions

  December 6, 2012 at 6:37 am

  #285909

  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