Post reply

Caclulate Distance

  • July 22, 2011 at 6:51 pm

    #100400

    Hi,

    how to calculate distance (in meters/KMs) between 2 lat/long as Cartesian product in 2 tables

    Thanks

    Grace

  • July 23, 2011 at 3:22 am

    #1357400

    This link should help you to get started.


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

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

  • July 23, 2011 at 11:46 pm

    #1357504

    Great Circle Distance Function - Haversine Formula

    http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=81360

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply