Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
My zipcode query is not returning the correct results
IT WORKED! Thank you so so so very much! -
My zipcode query is not returning the correct results
-14.270200000000001 70.603759999999994 -176.64435 166.410291 -
My zipcode query is not returning the correct results
Actually I have no idea if my latitude and longitude are in radians. You wouldn't have any idea how I might find out? -
My zipcode query is not returning the correct results
Well, that is just like something that I would do, however, I did check and found at least one other zipcode within 2.07 miles. which my code says is 23.5 miles away. (80250) -
My zipcode query is not returning the correct results
Thank you so much for the suggestion. Unfortunatley I still received the same answer. -
My zipcode query is not returning the correct results
The following query: CREATE PROCEDURE GetDistance AS SELECT a.ZIPCODE, a.CITY, a.STATE, ROUND( (ACOS( (SIN(c.LATITUDE) * SIN(a.LATITUDE)) + (COS(c.LATITUDE) * COS(a.LATITUDE) * COS(a.LONGITUDE - c.LONGITUDE)) ) )...
