I have a table containing US zipcodes, longitude, latitude. Using sql server 2005 geographical location data type can I get the zipcodes that are at a particular distance from my given zipcode?
What is the Sql query I have to write?
Example:
I want to get zipcodes that are 10 miles from zipcode 10001 (NYC)
www.ithighway.co.uk