This is a GIS problem. SQL Server actually supports Geography spatial types, which allows for geographical spatial math (like distance) on those coordinates.