What is the diffrence between Pivot an Unpivot
| These tow are th opertor in Sql Server 2005 these are used to manupulate a expression from one table into another table but bothe are opposite of each other Pivot take rows and put them into the column but on the other hand Unpivot take column and put them into the row.Pivots helps in rotating unique in one column from mutliple columns. | |