title: Find nearest Neighbour out of N points for M points
body: <p>I am currently trying to assign regions to customers by optimizing driving distance.
  So far I have generated a from/to/driving time table and for every point withing the problem I am aware in what position they reside.</p>
  
  <p>Thus I have a list a containing customer locations and a list b containing service locations. List be should be assigned to list a.
  For me it seems like every point in b should be evaluated on distance to a point in a and then assigned to the closest point. </p>
  
  <p>My question...would there be a way to solve this problem using regular msSQL?</p>