We need to display Map of locations within a give area. We do not want to upload the data but rather do a search on the local data by longitude/latitude
I checked the following microsoft article for that
Implementing a Proximity Search with SQL Server 2000
The third paramter to the stored procedure dbo.sp_FindNearby is SearchDistance but what should be the value of the last parameter @EarthRadius to call this stored procedure.