Calculate distance between two points

• Scott Coleman

  One Orange Chip

  Points: 27452

  More actions

  September 24, 2007 at 8:30 pm

  #175144

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

• jdurandt

  SSChasing Mays

  Points: 628

  More actions

  July 22, 2009 at 2:07 am

  #1028124

  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