Calculating distance between coordinates at server side.

DECLARE @sourceLatitude FLOAT = 30.704231;

DECLARE @sourceLongitude FLOAT = 76.79025380000007;

DECLARE @destinationLatitude FLOAT = 30.6649526;

DECLARE @destinationLongitude FLOAT = 76.73004209999999;

DECLARE @Location FLOAT

SELECT ACOS(SIN(@sourceLatitude * PI()/ 180) * SIN(@destinationLatitude * PI() / 180) +

COS(@sourceLatitude * PI() / 180) * COS(@destinationLatitude * PI() / 180) *

COS(( @destinationLongitude- @sourceLongitude) * PI()/ 180)) * 180 / PI() * 60 * 1.1515 * 1.609344

AS distance