Row to column convertion in sql server 2008

• anbu_21st

  SSC Rookie

  Points: 47

  More actions

  August 13, 2009 at 12:18 am

  #135320

  data

  empcode leavedate leavetype

  -------------------------------

  1 2009-08-14 CL

  1 2009-08-10 EL

  1 2009-08-09 LOP

  I Need Teh following Manner

  EmpCode 09 10 14

  ----------------------

  1 LOP El CL

• tim.keen

  Old Hand

  Points: 310

  More actions

  August 15, 2009 at 10:31 am

  #1039847

  try using pivot