Calculate Distance Between Locations in SQL Server?

Question

Hi I want to calculate a distance between two locations using Geograpy in SQL Server. Thanks in advance.

Thiyagarajan E · Answer

Hi Singaravel vela Use this below SQL function will help you. Now on SQL Server 2008 which is location aware this is much more efficient and easy to do using geography. Lets say that you have a table with locations called tblLocations which has stored in two columns the longitude( location_longitude) latitude(location_latitude) and you want to calculate the distance of those from a point. For Ex: CREATE PROCEDURE [dbo].[spGetNearLocations] @latitude decimal(1814) @longtitude decimal(1814) AS BEGIN SET NOCOUNT ON; -- @p1 is the point you want to calculate the distance from which is passed as parameters declare @p1 geography = geography::Point(@latitude@longtitude 4326); SELECT * @p1.STDistance([location_geography]) as [DistanceInKilometers] FROM [tblLocations] EN