title: SQL Loop through result set to assign employees
body: <p>I have the result of a select query that returns (for example) 10,000 rows in a specific order by sequence (by priority)</p>
  
  <p>I have 4 employees that I need to assign both equally in distribution (so everyone gets 2,500) AND by priority (so everyone gets an equalish amount of high priority work to complete)</p>
  
  <p>I'm working with two simple sets...</p>
  
  <p>My initial result set of 10,000 looks something like this:</p>
  
  <pre><code>Job Due Date    Assignment
  a   11/1/2015   
  b   11/1/2015   
  c   11/2/2015   
  d   11/3/2015   
  e   11/4/2015   
  f   11/4/2015   
  g   11/4/2015   
  h   11/4/2015   
  i   11/5/2015   
  </code></pre>
  
  <p>And my employees table is a simple:</p>
  
  <pre><code>Employees
  Tom
  Jerry
  Susan
  Rick
  </code></pre>
  
  <p>I need the end result to look something like:</p>
  
  <pre><code>Job Due Date    Assignment  
  a   11/1/2015   Tom
  
  b   11/1/2015   Jerry   
  c   11/2/2015   Susan   
  
  d   11/3/2015   Rick    
  e   11/4/2015   Tom 
  
  f   11/4/2015   Jerry   
  
  g   11/4/2015   Susan   
  h   11/4/2015   Rick    
  i   11/5/2015   Tom 
  </code></pre>
  
  <p>How can I iterate through my 10,000 records to assign my 4 employees at a time?</p>