title: Slice Data in SQL Server
body: <p>I want to slice number of rows into two per group.</p>
  
  <p>So for example if I have 10 rows and I want to slice it into 2 per group then both record should have same id.</p>
  
  <p>Input: </p>
  
  <pre><code>Name 
  adc
  abc
  Cdd
  Dee
  Eaa
  </code></pre>
  
  <p>Output should be two columns:</p>
  
  <pre><code>COUPLEID | NAME
         1   adc
         1   abc
         2   Cdd
         2   Dee
         3   Eaa
  </code></pre>