pivoting data

• vbandlamudi

  Mr or Mrs. 500

  Points: 542

  More actions

  August 27, 2008 at 11:45 pm

  #93853

  please check this out and help me to get result:

  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.

• ChrisM@Work

  SSC Guru

  Points: 186127

  More actions

  August 28, 2008 at 12:53 am

  #864148

  Duplicate post, see http://www.sqlservercentral.com/Forums/Topic559341-338-1.aspx

  ^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}

  For fast, accurate and documented assistance in answering your questions, please read this article.
  Understanding and using APPLY, (I) and (II) Paul White
  Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden