Recent PostsRecent Posts Popular TopicsPopular Topics
 Home Search Members Calendar Who's On

 Caclulate Distance Rate Topic Display Mode Topic Options
Author
 Message
 Posted Friday, July 22, 2011 6:51 PM
 Grasshopper Group: General Forum Members Last Login: Wednesday, November 20, 2013 3:12 PM Points: 20, Visits: 127
 Hi,how to calculate distance (in meters/KMs) between 2 lat/long as Cartesian product in 2 tables ThanksGrace
Post #1147003
 Posted Saturday, July 23, 2011 3:22 AM
 SSCertifiable Group: General Forum Members Last Login: Today @ 9:09 AM Points: 6,870, Visits: 12,508
 This link should help you to get started. LutzA pessimist is an optimist with experience. How to get fast answers to your question How to post performance related questionsLinks for Tally Table , Cross Tabs and Dynamic Cross Tabs , Delimited Split Function
Post #1147043
 Posted Saturday, July 23, 2011 1:06 PM
 SSC-Dedicated Group: General Forum Members Last Login: Today @ 12:44 PM Points: 34,537, Visits: 28,703
 gracebite (7/22/2011)Hi,how to calculate distance (in meters/KMs) between 2 lat/long as Cartesian product in 2 tables ThanksGraceActually, 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." -- 04 August 2013(play on words) "Just because you CAN do something in T-SQL, doesn't mean you SHOULDN'T." --22 Aug 2013Helpful Links:How to post code problemsHow to post performance problems
Post #1147111
 Posted Saturday, July 23, 2011 11:46 PM
 Hall of Fame Group: General Forum Members Last Login: Today @ 9:18 AM Points: 3,022, Visits: 10,988
 Great Circle Distance Function - Haversine Formulahttp://www.sqlteam.com/forums/topic.asp?TOPIC_ID=81360
Post #1147175

 Permissions