title: Assign Unique ID within groups of records
body: <p>I have a situation where I need to add an arbitrary unique id to each of a group of records. It's easier to visualize this below. </p>
  
  <p>Edited 11:26 est:
  Currently the lineNum field has garbage. This is running on sql server 2000. The sample that follows is what the results should look like but the actual values aren't important, the numbers could anything as long as the two combined fields can be used for a unique key.</p>
  
  <pre><code>OrderID      lineNum
  AAA          1
  AAA          2
  AAA          3
  BBB          1
  CCC          1
  CCC          2
  </code></pre>
  
  <p>The value of line num is not important, but the field is only 4 characters. This needs to by done in a sql server stored procedure. I have no problem doing it programatically.</p>