title: How to convert columns to rows in sql server
body: <p>Please consider this table:</p>
  
  <pre><code>ID         Page          Line           C01          C02          C03        
  ---------------------------------------------------------------------
  1          122            11             1            0            1
  1          123            11             1            1            1
  1          124            12             0            0            0
  1          125            16             1            0            1
  1          127            11             0            1            0
  </code></pre>
  
  <p>I want to convert this table to this one:</p>
  
  <pre><code>ID         Page          Line           City         Value
  -----------------------------------------------------------
  1          122            11            C01            1           
  1          122            11            C02            0  
  1          122            11            C03            1  
  1          123            11            C01            1  
  1          123            11            C02            1  
  1          123            11            C03            1  
  ...
  </code></pre>
  
  <p>How I can do this in appropriate way?</p>