Em Andamento

SQL Server Proximity Search Stored Proc

We need a stored procedure created that can take a zip code and distance as an input and return a data set containing records that are within N miles radius of the provided zip code.

We are storing data that contains zip codes and latitude/longitude data. The stored procedure will take a zip code input and distance, lookup the latitude/longitude from the database, and then search a table containing numerous latitude/longitude coordinates and return only those within the distance radius from the provided zip code.

For example, Execute spGetProximty 94111, 10 will return all points in the table within 10 miles of zip code 94111.

Candidates will have strong experience building optimized SQL Server 2000/2005 stored procedures and an understanding of the math involved in doing radius proximity calculations. Samples code and references required.

I am aware of sample code that does proximity searching in a stored proc. While this may serve as a basis for this solution, it does not match our requirements and is not optimized.

Experienced candidates should have no problem estimating this small job.

Successful completion leads to ongoing project work.

Thank you.

Habilidades: .NET, Processamento de dados

Veja mais: server prox, sql server 2005 search stored proc, optimized proximity search sql server, find zip code latitude sql, sql server latitude longitude distance stored procedure, sql search latitude, sql server 2005 radius search, sql stored procedure zipcode distance, sql server radius search, proximity search sql, proximity search sql server 2005, sql server 2005 specify proximity word distance, sql server proximity search, work search, we search you, search we, search in.net, searching problem, search in code, search for solution

Acerca do Empregador:
( 1 comentário ) Wellsville, United States

ID do Projeto: #57850