cols to rows

• fasttrack

  SSCertifiable

  Points: 6071

  More actions

  November 21, 2005 at 1:48 pm

  #102944

  I have a problem:

  I fill a table from the result a query and obtain a table like:

  Item    value

  aa       12

  bb       78

  cc       23

  I would like to trasform the table with 1 row and cols the rows:

  In this way:

  aa     bb     cc

  12     78     23

   

  Any suggestion will be very appreciated.

  thank

  

   

• David A. Long

  SSCrazy Eights

  Points: 8421

  More actions

  November 21, 2005 at 11:07 pm

  #605141

  Try searching for Pivot, there are many examples, choose the one that fits your situation like:

  http://www.sqlservercentral.com/scripts/contributions/204.asp

  or

  http://www.sqlservercentral.com/scripts/contributions/506.asp

  Andy