SQL to find nearest location in one table from locations in another
construct a sql select that for every row in SourceData find an entry(ies) in NewLocations that is within a few metres


Something like:

select *
from NewLocations n
cross join SourceData s
where originalLocation.STDistance(NewLocation) &lt; 5