Home Forums SQL Server 2008 SQL Server 2008 - General Optimize query for finding nearest airport based on latitude and longitude using STDistance RE: Optimize query for finding nearest airport based on latitude and longitude using STDistance
amTryingSoHard
Mr or Mrs. 500
Points: 594
More actions
April 28, 2012 at 9:02 pm
#1480888
Hello Jeff.
I was thinking about your suggestion. Is it somehow similar to this?
I will get the min/max lat and long based on the flight log. Get the distance between the min/max lat/long and limit the airports based on that distance?
Thank you.