Calculate Distance Between Locations in SQL Server?

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(18,14),
@longtitude decimal(18,14)
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

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Thiyagarajan E9y ago
Accepted 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(18,14),
@longtitude decimal(18,14)
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