Home Forums SQL Server 2005 Development Caclulate Distance RE: Caclulate Distance

  • July 23, 2011 at 1:06 pm

    #1357448

    gracebite (7/22/2011)

    Hi,

    how to [font="Arial Black"]calculate distance (in meters/KMs) between 2 lat/long [/font]as Cartesian product in 2 tables

    Thanks

    Grace

    Actually, if you Google'd/Yahoo'd what I've highlighted in your original question above, you'd have gotten all the information you need without having pri knowledge that these are affectionately referred to as "Great Circle Calculations". Give it a try.

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)