With 1.7 million freelancers, we'll match you with the perfect talent.
The client has made the following changes to the job.
Client prefers freelancers from:
You are still able to submit a proposal for this job.
The client prefers freelancers from
a different location.
This web service has 4 methods, very simple and similar among them,
there are 4 tables in sql server each contains a list.
I will provide definition of tables.
there will be 4 sql server stored procedures. I will provide stored procedure almost done.
each method returns all the records that match certain criteria contained in a sql server stored procedure.
I will provide the starting code of the stored procedure, is almost done, just needs minor modifications.
Basically each method returns a list of locations around 25 miles a given zip code. from the corresponding tables. Using each stored procedure that belongs to each method.
The logic to determine the distance is contained in the stored procedure I will provide.
That's all there's to it. Will post sproc code and table definition shortly.
Sign in or Register to see more