title: SQL Server 2008 : Convert column value to row
body: <p>I have a table in the following format</p>
  
  <pre>
  Country_Code | 1960 | 1961 | 1962 | ..... | 2011
  ------------------------------------------------
  IND          | va11 | va12 | va13 | ..... | va1x
  AUS          | va21 | va22 | va23 | ..... | va2x
  ENG          | va31 | va32 | va33 | ..... | va3x
  </pre>
  
  <p>I want to convert it into the below format</p>
  
  <pre>
  Country_Code | Year | Value
  ---------------------------
  IND          | 1960 | va11
  IND          | 1961 | va12
  IND          | 1962 | va13
  .
  .
  IND          | 2011 | va1x
  AUS          | 1960 | va21
  AUS          | 1961 | va22
  AUS          | 1962 | va23
  .
  .
  AUS          | 2011 | va2x
  ENG          | 1960 | va31
  ENG          | 1961 | va32
  ENG          | 1962 | va33
  .
  .
  ENG          | 2011 | va3x
  
  </pre>
  
  <p>How can this be achieved by sql query or sql server assembly ?</p>