Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Calculate distance between two points Expand / Collapse
Author
Message
Posted Monday, September 24, 2007 8:30 PM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Thursday, September 11, 2014 8:07 AM
Points: 2,844, Visits: 1,154
Comments posted to this topic are about the item Calculate distance between two points


Post #402330
Posted Wednesday, July 22, 2009 2:07 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Tuesday, May 14, 2013 12:40 PM
Points: 54, Visits: 145
Hi Scott

A nice approach - although I do this in my application server when querying with LINQ rather than on the database. Of course sometimes that is not practical (Like when searching large volumes of data), so having this as a backup is very useful

What I did do for my function (and recommend that you do for yours ) is to include in the name what measurement unit it is in - the difference between functions that return values in Miles and those that return values in Kilometres comes up all over the show in bug reports. So I would call it "fn_latlondistance_mi"

Regards,
Joon
Post #757202
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse