Convert Rows into Columns

• Sanket-267266

  SSC-Addicted

  Points: 418

  More actions

  April 26, 2006 at 11:48 pm

  #112604

  Hi,

  I have one table named "TblTest" when i use select * from TblTest then I got this result

  ID      QUE                             ANS

  1      Name                            sanket

  1      AGE                              27

  2      Name                            sanjay

  2      AGE                              26

  now I want to convert this output to below format like rows into columns like this

  ID   Name     AGE

  1    sanket    27

  2    sanjay    26

  Please send solution i just need this result to export to CSV file.

   

   

   

   

   

  Regards

• RyanRandall

  SSChampion

  Points: 13623

  More actions

  April 27, 2006 at 3:18 am

  #634504

  Hi Sanket,

  This is very commonly requested. These articles should help you find the technique that will work best for you...

  http://www.sqlteam.com/item.asp?ItemID=2955

  http://www.sqlteam.com/item.asp?ItemID=5741

  Ryan Randall

  Solutions are easy. Understanding the problem, now, that's the hard part.

• Sanket-267266

  SSC-Addicted

  Points: 418

  More actions

  April 27, 2006 at 4:35 am

  #634517

  Thanks Dear

  Regards