Calculating Distance

• jhklink

  Mr or Mrs. 500

  Points: 582

  More actions

  November 17, 2003 at 1:24 pm

  #83481

  I would like to use code to calculate distance using a fixed Long/Lat and a variable Long/Lat. Any ideas would be wonderful

• jmadsen

  SSC Veteran

  Points: 285

  More actions

  November 17, 2003 at 3:37 pm

  #482322

  I used Google and found these links:

  http://jan.ucc.nau.edu/~cvm/latlongdist.html (code is in Perl)

  http://www.freevbcode.com/ShowCode.Asp?ID=5532 (code is in VB)

  http://www.hotscripts.com/Detailed/20791.html (various code, including C/C++)

  I might take a crack at convert it to T-SQL myself, but don't wait on me 🙂

  Jeff

• Crispin Proctor

  SSCoach

  Points: 18161

  More actions

  November 17, 2003 at 10:16 pm

  #482355

  Credit to Neil.

  http://www.sqlservercentral.com/scripts/contributions/660.asp

  Cheers,

  Crispin

  Cheers,CrispinI can't die, there are too many people who still have to meet me!It's not a bug, SQL just misunderstood me!