Query to change rows as columns

• balu-1123884

  SSC Rookie

  Points: 34

  More actions

  February 8, 2012 at 4:18 am

  #255282

  Hi,

  I have table like

  Name Type Cost

  ABTRAVELSIndica:4 88284.5833333333

  ABTRAVELSLuxury Bus:180

  ABTRAVELSSumo:6 27037.3333333333

  ABTRAVELSTavera:8 50

  I want result like

  Indica:4 Luxury Bus:18 Sumo:6Tavera:8

  ABTRAVELS 88284.5833333333 0 27037.3333 50

  Please suggest any query for this

  Regards,

  Balu Reddy K

• Brigadur

  SSCrazy

  Points: 2097

  More actions

  February 8, 2012 at 4:44 am

  #1444421

  Hi,

  You might check pivot: Using PIVOT and UNPIVOT

• Cadavre

  SSC-Forever

  Points: 41690

  More actions

  February 8, 2012 at 4:46 am

  #1444422

  balu-1123884 (2/8/2012)

  ---

  Hi,

  I have table like

  Name Type Cost

  ABTRAVELSIndica:4 88284.5833333333

  ABTRAVELSLuxury Bus:180

  ABTRAVELSSumo:6 27037.3333333333

  ABTRAVELSTavera:8 50

  I want result like

  Indica:4 Luxury Bus:18 Sumo:6Tavera:8

  ABTRAVELS 88284.5833333333 0 27037.3333 50

  Please suggest any query for this

  Regards,

  Balu Reddy K

  Read this article then post your data and DDL in a readily usable fashion. Help us to help you!! Everyone here is an unpaid volunteer, you are much more likely to get working, tested code if you post readily consumable data and DDL.[/url]

  Thanks.

  ---

  Forever trying to learn
  My blog - http://www.cadavre.co.uk/
  For better, quicker answers on T-SQL questions, click on the following...http://www.sqlservercentral.com/articles/Best+Practices/61537/
  For better, quicker answers on SQL Server performance related questions, click on the following...http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

  ---