Calculate Distance Between Two Points

Question

Post reply

Calculate Distance Between Two Points

MuhammadShafiq

SSCrazy

Points: 2509
More actions
May 22, 2012 at 1:08 pm

#261250

Comments posted to this topic are about the item Calculate Distance Between Two Points

Viewing 9 posts - 1 through 8 (of 8 total)

You must be logged in to reply to this topic. Login to reply

jason 63816 SSC Enthusiast Points: 129 More actions · Answer 1

You could also use the STDistance function on 2 geo columns/objects?

krowley Ten Centuries Points: 1344 More actions · Answer 2

I noticed you were using and passing floats rather than the new spacial data types introduce in SQL Server 2008. Any reason why?

MSzI SSCommitted Points: 1529 More actions · Answer 3

Very nice script but it's not stable.

Check the following examples:

1. select dbo.MyDistance(46.192131,21.274666,46.192131,21.274665)

2. select dbo.MyDistance(46.192131,21.274666,46.192131,21.274666)

Both examples will give the following error:

Msg 3623, Level 16, State 1, Line 1

An invalid floating point operation occurred.

Keep improving it!

MuhammadShafiq SSCrazy Points: 2509 More actions · Answer 4

MSzI (6/15/2012)
Very nice script but it's not stable.
Check the following examples:
1. select dbo.MyDistance(46.192131,21.274666,46.192131,21.274665)
2. select dbo.MyDistance(46.192131,21.274666,46.192131,21.274666)
Both examples will give the following error:
Msg 3623, Level 16, State 1, Line 1
An invalid floating point operation occurred.
Keep improving it!

I run both your query,here is no issue.see the attached..as the difference is too small so 0 is ans...if i cange your query to select dbo.Distance(46.192131,21.274666,46.292131,21.374666) then you can see distance.see the attached

MuhammadShafiq SSCrazy Points: 2509 More actions · Answer 5

krowley (6/12/2012)
I noticed you were using and passing floats rather than the new spacial data types introduce in SQL Server 2008. Any reason why?

it was for SQL Server2005.i have a small application from where a user can click on two different locations and this function return distance....as from google map we get Lat,Lon.that is why i have used this data type...