Can u somebody explain how to find the proximity of the zip code ...using zip code database

__________________
The KINGMAKER
Makes Every Thing Possible

Stuffs (My Blog)

I want to Locates ZIP Codes that are within close proximity of a specified ZIP Code. specify the radius distance in miles, to find a list of ZIP Codes that fall within that radius is displayed

__________________
The KINGMAKER
Makes Every Thing Possible

Stuffs (My Blog)

The below SP supports and find the list of Zipcode within radius


CREATE PROC GetZipCodesWithinRadius

@ZipCode char(5) ,
@GivenMileRadius int
AS
SET NOCOUNT ON

DECLARE @lat1 float,
@long1 float

SELECT @lat1= latitude,
@long1 = longitude
FROM ZipSource
WHERE zipcode = @ZipCode

SELECT ZipCode ,DistanceInMiles
FROM
(
SELECT ZipCode,3958.75 * ( Atan(Sqrt(1 - power(((Sin(@Lat1/57.2958) * Sin(latitude/57.2958)) +
(Cos(@Lat1/57.2958) * Cos(latitude/57.2958) * Cos((longitude/57.2958) - (@Long1/57.2958)))), 2)) /
((Sin(@Lat1/57.2958) * Sin(latitude/57.2958)) + (Cos(@Lat1/57.2958) * Cos(latitude/57.2958) *
Cos((longitude/57.2958) - (@Long1/57.2958)))))) DistanceInMiles
FROM ZipSource
) a
WHERE a.DistanceInMiles <= @GivenMileRadius
--AND ZipCode <> @ZipCode
ORDER BY DistanceInMiles

GO

EXEC GetFindZipCodesWithinRadius '11566',20
GO


Do u have zip code ?did u purchase the ZipCode DB....

__________________
The MOSS
Master of Solution Service

No....I got from surfing in google as dmp file that is approx 54mb(43,000 records)


forgot the URL..........

__________________
The KINGMAKER
Makes Every Thing Possible

Stuffs (My Blog)