Retrieve columns names

• Amaury

  Mr or Mrs. 500

  Points: 546

  More actions

  July 19, 2006 at 4:18 pm

  #114299

  Hello there!

  Question: is there a transact statement for retrieving the data set in opposite order? I mean, we have for example:

  select number, name from tabla1

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

  Number Name

  1         name1

  2         name2

  could we have something as?

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

  Number     1            2

  Name        name1     name2

   

  Probably this sounds nuts but I'm just wondering if it's possible...

  Thanks!

  
  

  L.I. Amaury C.R.

• Pam Brisjar

  SSChampion

  Points: 12094

  More actions

  July 19, 2006 at 4:24 pm

  #650267

  What you're looking to do is a PIVOT.  If you've got 2005 it's fairly simple.  If not, search this forum and you'll find several examples.