title: Dividing Large dataset into equal lists in SQL
body: <p>i have 2 SQL databases, 1 being a list of agents and the other being clients.</p>
  
  <p>i would like to randomly split the client database amongst the number of agents i have. ie
  if i have 10 agents and 50 000 clients, each agent must get an equal unique list based on the number of clients available. (10 lists of 5000 totally random selected clients without any duplication)</p>
  
  <p>i am still very much a novice at at SQL and have tried to assign ID numbers to the client list based on the amount of agents i have and then joining them up like that. I would like to try something a bit more random than just going 1,2,3, and joining them up like tht</p>
  
  <p>i would like to do it either in SQL or Excel.</p>
  
  <p>Please Help...</p>