Cross Tab query

• r.abdur

  Newbie

  Points: 5

  More actions

  October 23, 2008 at 10:51 am

  #383204

  Hi Guys,

  I have a SP which returns me data in following format

  EmpColumanname

  BL00001

  BL00002

  BL00003

  BL00004

  BL00005

  BL00006

  BL00007

  ColumeName

  2008-10-21

  2008-10-22

  2008-10-23

  2008-10-24

  Now,i want this to convert to below format

  EmpColumanname 2008-10-21 2008-10-22 2008-10-23 2008-10-24

  BL00001

  BL00002

  BL00003

  BL00004

  BL00005

  BL00006

  BL00007

  for a clear picture..i am attaching screen shot.please have a look and please me.

• Jack Corbett

  SSC Guru

  Points: 184394

  More actions

  October 23, 2008 at 2:00 pm

  #888859

  Check out this article: http://www.sqlservercentral.com/articles/T-SQL/63681/

  Jack Corbett
  Consultant - Straight Path Solutions
  Check out these links on how to get faster and more accurate answers:
  Forum Etiquette: How to post data/code on a forum to get the best help
  Need an Answer? Actually, No ... You Need a Question