Find the nearest bank subsidary using geography datatype in SQL Server 2008

In this example we will explore how to calculate the nearest point of interest of e.g. a business relative to our current location. For example we are at MS Austria subsidiary in Vienna and we want to go to the bank and therefore we are interested where the nearest Raiffeisen Bank subsidiary is. Finally we…

1

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…

0