Columns to Rows

• Knp77

  Grasshopper

  Points: 11

  More actions

  January 4, 2009 at 10:38 am

  #73167

  Hi All,

  I have a table where I need to convert columns to Rows. The data looks like

  Description Rule1 Rule2 Rule3

  Default1 100 150 200

  Default1 50 100 200

  Default2 150 400 120

  Default2 250 300 120

  I want it to change to

  NewDescription NewRule Value

  Default1 Rule1 150

  Default1 Rule2 250

  Default1 Rule3 400

  Default2 Rule1 400

  Default2 Rule2 700

  Default2 Rule3 420

  Note that 'Value' is the sum of 'Rule1' for Default1 in the original table and so on.

  Thanks.

• Ron McCullough

  SSC Guru

  Points: 63877

  More actions

  January 4, 2009 at 11:16 am

  #920877

  Here are two (2) excellent articles by Jeff Moden which will explain how to perform what you need along with detailed sample code:

  http://www.sqlservercentral.com/articles/T-SQL/63681/

  http://www.sqlservercentral.com/articles/cross+tab/65048/

  If everything seems to be going well, you have obviously overlooked something.

  Ron
  
  Please help us, help you -before posting a question please read[/url]
  Before posting a performance problem please read[/url]

• nigel.

  SSChampion

  Points: 11636

  More actions

  January 6, 2009 at 9:59 am

  #921933

  See the link below for a good example of doing an 'UNPIVOT' with SQL 2000

  http://wardyit.com/blog/blog/archive/2006/05/16/105.aspx

  Nigel
  How to post questions