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
 SSC Rookie Group: General Forum Members Last Login: Friday, August 29, 2014 11:07 AM Points: 25, Visits: 152
 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: Wednesday, February 10, 2016 11:50 AM Points: 6,897, Visits: 13,559
 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-Forever Group: General Forum Members Last Login: Today @ 3:29 PM Points: 42,079, Visits: 39,468
 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." Helpful 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: Saturday, October 24, 2015 2:31 AM Points: 3,158, Visits: 11,771
 Great Circle Distance Function - Haversine Formulahttp://www.sqlteam.com/forums/topic.asp?TOPIC_ID=81360
Post #1147175

 Permissions