pivot and unpivot

• weston_086

  SSCommitted

  Points: 1645

  More actions

  January 25, 2012 at 11:47 pm

  #254238

  Hi everyone,

  i want to know what is the main difference between pivot and unpivot.i know what pivot does but i am not getting unpivot.

  Thanks

• Dave Ballantyne

  SSC-Dedicated

  Points: 33667

  More actions

  January 25, 2012 at 11:58 pm

  #1438578

  Pivot will 'convert' rows to columns , un-pivot will go the other way columns to rows

  This link contains some full examples

  http://msdn.microsoft.com/en-us/library/ms177410.aspx

  ---

  
  Clear Sky SQL
  My Blog[/url]

• johnitech.itech

  Hall of Fame

  Points: 3252

  More actions

  January 26, 2012 at 6:43 am

  #1438737

  :hehe:

  Ok ,Also see below ARTICLE

  http://blog.sqlauthority.com/2008/06/07/sql-server-pivot-and-unpivot-table-examples/[/url]