converting rows to columns

• sql_learner29

  SSCrazy Eights

  Points: 9107

  More actions

  July 1, 2010 at 11:20 am

  #237170

  any help on this:

  http://www.sqlservercentral.com/Forums/Topic946357-148-1.aspx

  [font="Comic Sans MS"]
  ---------------------------------------------------

  Thanks [/font]

• Mike01

  SSChampion

  Points: 11395

  More actions

  July 1, 2010 at 12:20 pm

  #1187842

  I'll reply on the main thread instead of this one

  For better, quicker answers, click on the following...
  http://www.sqlservercentral.com/articles/Best+Practices/61537/

  For better answers on performance questions, click on the following...
  http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

• Ram:)

  SSCrazy

  Points: 2246

  More actions

  July 1, 2010 at 12:43 pm

  #1187854

  I don't know it will work for you or not..

  SELECT TRAN_ID,DATE,TYPE,CANC,CEMP,DHKP,GECD,GMVD,IHHE,INPH,ACTION_DATE FROM

  (SELECT TRAN_ID,DATE,TYPE,MIN(EMP) AS EMP,ACTION,ACTION_DATE FROM #TEST GROUP BY TRAN_ID,DATE,TYPE,ACTION,ACTION_DATE) AS P

  PIVOT

  (MIN(P.EMP) FOR P.ACTION IN (CANC,CEMP,DHKP,GECD,GMVD,IHHE,INPH)) AS PVT

  ORDER BY TRAN_ID

  🙂

• Jeff Moden

  SSC Guru

  Points: 1004363

  More actions

  July 1, 2010 at 2:42 pm

  #1187915

  priya__ (7/1/2010)

  ---

  any help on this:

  http://www.sqlservercentral.com/Forums/Topic946357-148-1.aspx

  I'd say "Not on this thread". Keep your stuff together, please... especially since you already have an answer on the other thread.

  --Jeff Moden

  ---

  RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
  First step towards the paradigm shift of writing Set Based code:
  ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

  Change is inevitable... Change for the better is not.
  

  ---

  Helpful Links:
  How to post code problems
  How to Post Performance Problems
  Create a Tally Function (fnTally)