Calculate distance between two points

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by Scott Coleman » Calculate distance between two points

Calculate distance between two points

Rate Topic

Display Mode

Topic Options

Author

Message

Scott Coleman

Posted Monday, September 24, 2007 8:30 PM

SSCrazy

Group: General Forum Members
Last Login: Thursday, May 16, 2013 11:38 AM
Points: 2,818, Visits: 1,037

Comments posted to this topic are about the item Calculate distance between two points

Post #402330

jdurandt

Posted Wednesday, July 22, 2009 2:07 AM

Valued 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 Smile

) 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 »

Permissions