Calculating a distance between two points of interest using SQL Server 2008 geography data type

With this post we want to present an example how to use the new SQL Server 2008 Spatial Data-types by calculating the distance between two points of interest.   SQL Server 2008 introduced two spatial data types: ·         geography and ·         geometry.   Lots of explanations and examples for these already exist on the Internet…