Help needed in PIVOT

• hbanerje

  SSC Eights!

  Points: 818

  More actions

  June 20, 2012 at 10:06 am

  #271514

  Sorry I forgot to paste the code in the previous email.

  Select

  COUNT (MS_DRG) as 'cntof MS_DRG',ms_drg, FYFP,

  MS_DRG as '765',

  MS_DRG as '766',

  FYFP

  from #TSI_patient_list_Csections

  group by FYFP,ms_DRG

  I need the table to look like this ...

  FYPer/Yr 765766

  4/2012 4041

  5/2012 3853

• Lynn Pettis

  SSC Guru

  Points: 442467

  More actions

  June 20, 2012 at 10:10 am

  #1503572

  Please post answers here.

  No reason to start another thread.