Accepted answer

While not a SQL answer, I always recommend this explanation for how to calculate distances between lat-lng -

For SQL Server, assuming you are using SQL Server 2008, then you can use the native SQL geography types. However, sadly I don't think these map well to Linq-2-Sql so you will probably need to wrap them within stored procedures.


Related Articles