Converting Rows into Column - Crosstab format: Please help ASAP

• rahulzeel

  Valued Member

  Points: 55

  More actions

  September 24, 2009 at 10:01 pm

  #73325

  Hello,

  I have a table ITEM_MST

  ITEM_TYPE QTY Date

  1 2 15 July 2009

  1 4 16 July 2009

  2 3 17 July 2009

  2 1 18 July 2009

  1 4 19 July 2009

  1 6 20 July 2009

  1 2 21 July 2009

  I wan the output in this format

  ITEM_TYPE QTY1 QTY2 QTY3

  1 2 4 4

  1 6 2

  2 3 1

  I dont want to use any aggregate functions as there is nothing to aggregate.

  Please let me know the solution for the same ASAP.

  Thanks and Regards

  Rahul

• Sergiy

  SSC Guru

  Points: 110208

  More actions

  September 25, 2009 at 7:05 am

  #1058430

  Can you explain the logic of the output?

  _____________
  Code for TallyGenerator