title: Database Pivoting - what is the purpose?
body: <p>Why would someone want to convert columns into rows (ie pivoting)? Which problem does it solve?</p>
  
  <p>I found some links, but did not get satisfactory answers to the questions.</p>
  
  <p><a href="http://codeghar.wordpress.com/2007/11/03/pivot-tables/">http://codeghar.wordpress.com/2007/11/03/pivot-tables/</a></p>
  
  <p><a href="http://msdn.microsoft.com/en-us/library/ms177410%28SQL.105%29.aspx">http://msdn.microsoft.com/en-us/library/ms177410%28SQL.105%29.aspx</a></p>