title: how to add even row number data into first column and odd row number data into the second column?
body: <p>I need a help to add even row number data into first column and odd row number data into the second column. Using SQL server 2008 / SQL server 2008 R2...</p>
  
  <p><strong>Example</strong></p>
  
  <pre><code>id      Data
  1       TK104
  2       ABC   
  3       TK106
  4       XYZ
  </code></pre>
  
  <p><strong>LOOKING FOR OUTPUT LIKE</strong></p>
  
  <pre><code>NAME          VALUE
  TK104         ABC
  TK106         XYZ
  </code></pre>