What I am looking for is a MS SQL server based script (read: SQL stored procedure) that will allow me to pass 3 variables, a zipcode, a mile amount, UserType.
All my users, and locations each have a zip code. I want to allow people to type in a zip code (or automatically use the zip code in their profile) and a distance upto 500 miles.
This stored procedure will then generate a list of the selected type (location, users etc) that are within that range.
There are many examples of how to do this, so you can come up with many ideas on how this works (myspace is a good example).
This script should also allow people to type in a zipcode and have a distance generated in miles (you are xxx miles from this location).
There are many examples all ready out there on how you can do this all ready (search [login to view URL] for zip code) what I am paying for is a script that is specific to my needs.
## Deliverables
1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.
2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables):
a) For web sites or other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment.
b) For all others including desktop software or software the buyer intends to distribute: A software installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request.
3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement).
## Platform
Windows 2003
ASP Classic (3.0)
MS SQL Server 2000
Stored procedure.