The initial Function No1 is:

Declare @ProximityMetersLimit integer
Declare @TaskStatus nvarchar(100)
Declare @TaskGID nvarchar(100)
Declare @Count as int
Declare @Latitude as decimal(25,10)
Declare @longitude...

Yes @Eirikur i am trying to calculate the geographical distance.

DECLARE @LAT1 FLOAT = 37.6053577010;
DECLARE @LONG1 FLOAT = 26.2733349949;
DECLARE @LAT2 FLOAT = 37.6053577010;
DECLARE @LONG2...

Dear Debasis,

Can you please post a code-example of what you propose please?

Thanks a lot.

Thank you guys, for your replies.

So the best idea is to rewrite the same query in a different apporach?