title: how to move rows from the begining of a table to the end of it?
body: <p>I have a Table: </p>
  
  <pre><code>tblRows (RowIndex int identity,  Data int)
  </code></pre>
  
  <p>what is the best way to take X  rows and move it to the end of the table? 
  for example , let's say there are 1000 rows in the table, RowIndex is 1-1000.
  i want to move first 50 rows to the end, so now RowIndex will be 51-1050.</p>
  
  <p>Should i use Delete and then insert or use update?</p>
  
  <p>The Data Column must be unique , so delete first and then insert is possible.</p>
  
  <p>The order of the row is important.</p>