convert different rows ( dynamic no.of rows ) into different columns

• vbandlamudi

  Mr or Mrs. 500

  Points: 542

  More actions

  August 27, 2008 at 11:19 pm

  #864128

  please check this out:

  my data is like as folows

  order_num prdo_grp level

  10001 [lux][santoor] 1

  10002 [grp][app] 2

  20003 [htc][hutch] 3

  result should be like as follows[ contains only one record]

  order_num submission order1 order2 order3

  10001 [lux][santoor] [grp][app] [htc][hutch] null

  everytime it should take the order number as level1 order number.

• Michael Meierruth

  SSChampion

  Points: 10051

  More actions

  August 28, 2008 at 12:37 am

  #864142

  vbandlamudi,

  How many times are you going to post this problem?

  What you are doing is bad forum etiquette!

  In addition, your problem is incomprehensible.

  Maybe with some additional and more varied sample data presented in 'standard form' it might be possible to understand your problem.

  But please delete your duplcate entries.