|
Subject:
|
Query Sql Server 2005, geographical data
|
|
Posted By:
|
itHighway
|
Post Date:
|
6/3/2008 11:25:14 PM
|
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
|
|
