title: How to create sequential number column index on table with data
body: <p>I have the following table with 10 unique rows, BookingID is a FK containing a random number. The number doesn't need to be in sequence.</p>
  
  <pre><code>BookingID, Description
  1000       Foo
  3000       Bar
  1500       Zoo
  </code></pre>
  
  <p>I need to insert an sequential index called ID which goes from 1..x</p>
  
  <p>how do I do that in SQL Server 2005? I was thinking to write a cursor and x=x+1 but maybe there is a better way? </p>
  
  <p>This is the result I want</p>
  
  <pre><code>Id, BookingID, Description
  1   1000       Foo
  2   3000       Bar
  3   1500       Zoo
  </code></pre>