DECLARE @Latitude Float DECLARE @Latitude2 Float DECLARE @Longitude Float DECLARE @Latitude3 Float DECLARE @Latitude4 Float DECLARE @Longitude2 Float DECLARE @Longitude3 Float SET @Latitude=47.7795 SET @Latitude2=47.7795 SET @Longitude=-65.7191 SET @Latitude3=47.7795 SET @Latitude4=47.7795 SET @Longitude2=-65.7191 SET @Longitude3=-65.7191 SELECT Result.Latitude,Result.Longitude FROM (SELECT * FROM Client CROSS APPLY (SELECT SIN(@Latitude/57.2957795130823)*SIN(Latitude/57.2957795130823)+ COS(@Latitude2/57.2957795130823)*COS(Latitude/57.2957795130823)* COS(Longitude/57.2957795130823-@Longitude/57.2957795130823) AS Temp) Temp WHERE (Latitude>=@Latitude3-250/111.0 AND Latitude<=@Latitude4+250/111.0) AND (Longitude>=@Longitude2-250/111.0 AND Longitude<=@Longitude3+250/111.0)) Result WHERE 3958.75586574*ACOS(CASE WHEN Temp > 1 THEN 1 WHEN Temp < -1 THEN -1 ELSE Temp END)<=250In the result, I would like to obtain the distance. What kind of modifications can I apply to obtain the distance value from the point of origin for all records as par of the result set?