Pivoting in SQL 2000

• MANU-J.

  SSC-Dedicated

  Points: 31126

  More actions

  December 3, 2008 at 1:37 pm

  #73119

  Hi,

  Can someone please tell me how to convert the following data

  NameRoll ID

  P12034

  J121341

  To

  P J

  120 121

  34 341

  Thanks,

  MJ

• Jack Corbett

  SSC Guru

  Points: 184394

  More actions

  December 3, 2008 at 1:47 pm

  #907138

  Check out this article[/url]and part 1 which is linked in the article

  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

• shinde.nilam20

  Grasshopper

  Points: 14

  More actions

  December 29, 2009 at 9:20 am

  #1097073

  MANU-296622 (12/3/2008)

  ---

  Hi,

  Can someone please tell me how to convert the following data

  NameRoll ID

  P12034

  J121341

  To

  P J

  120 121

  34 341

  Thanks,

  MJ