Microsoft SQL Server offers the STDistance method to calculate the shortest distance between two geography points with high accuracy.
[HOWTO] Calculate distance between two points (coordinates) on Microsoft SQL Server
Tag: Microsoft SQL Server
blog.rufer.be 