Encerrado

Distance Calculator - finding close customers

We have a list of retail store locations for different retail stores throughout the United States. We also have a list of addresses for all of our customers. Given the zip codes of a list of retail store locations get a list of all customer information for customers that live within X miles of one of the locations.

NOTE: We will supply latitude and longitude for each zip code.

## Deliverables

Given the data in tblStoreLocations, use [url removed, login to view] to calculate the distance between each zip code in tblAddresses, returning all customer information in tblAddresses for each zip code that is within X miles. We would like this to be written in such a way that it can easily be run repeatedly (most likely a stored procedure) with parameters that allow us to easily change the StoreID and distance. It also needs to run as fast as possible. Ideally we would like it run run in a few minutes, but _we may choose_ to accept solutions that require longer to execute. Regardless of execution time, this needs to run without causing excessive locking, as this would compromise performance of other websites and applications.

What makes it challenging is that we have some stores with a ton of locations (like over 1,500), and we have a fair number of customers (about 25,000 distinct zip codes). That means there are roughly 38 million combinations to compare. The server this will be running on is powerful enough that this *should* run relatively quickly. You will be developing on a slower non-production server though. Here is the result set we want:

[url removed, login to view]

[url removed, login to view]

[url removed, login to view]

[url removed, login to view]

[url removed, login to view]

[url removed, login to view]

[url removed, login to view]

[url removed, login to view]

[url removed, login to view]

[url removed, login to view]

[url removed, login to view]

[url removed, login to view]

[url removed, login to view]

[url removed, login to view]

[url removed, login to view] (rounded to one decimal place)

If a particular address record is found to be within X miles of more than one retailer, the closest retailer should be matched. The extraneous matches can be discarded.

The "product" here can be either a stored procedure or some kind of software. We are running Microsoft SQL Server 2000. If you want to give us an application, all source code will be required. The server is running the Windows platform and has the .Net Framework installed (2.0) as well as the JRE v.6.

## Platform

Operating System: Windows

SQL Server: Microsoft SQL Server 2000

Habilidades: .NET, Programação C, Programação C#, Engenharia, Java, MySQL, PHP, Arquitetura de software, Teste de Software, SQL, Visual Basic

Ver mais: what is a programming framework, sql php application without programming, powerful programming software, operating system programming, net programming websites, most powerful websites, finding websites, finding net, finding matches, calculator programming, rounded calculator, finding locations, finding information, Email Finding, distance calculator, distance zip code, zipcode city, retail software source code, calculator data, city state zip codes, stored procedure list, windows phone source codes, code calculator, distance calculate, application calculator

Acerca do Empregador:
( 2 comentários ) United States

ID do Projeto: #2972228

28 freelancers estão ofertando em média $208 para este trabalho

shupantha

See private message.

$233.75 USD in 30 dias
(77 Comentários)
7.3
suthernsoftware

See private message.

$170 USD in 30 dias
(61 Comentários)
6.6
bitdonkey

See private message.

$212.5 USD in 30 dias
(115 Comentários)
6.2
zahidagh

See private message.

$238 USD in 30 dias
(25 Comentários)
6.1
edule

See private message.

$170 USD in 30 dias
(4 Comentários)
5.8
pmndesai

See private message.

$127.5 USD in 30 dias
(30 Comentários)
5.3
toinnisfreesl

See private message.

$212.5 USD in 30 dias
(36 Comentários)
5.3
stamparmiroslav

See private message.

$255 USD in 30 dias
(45 Comentários)
5.1
senzaciosnegyes

See private message.

$170 USD in 30 dias
(104 Comentários)
4.9
kamranhussainvw

See private message.

$246.5 USD in 30 dias
(12 Comentários)
4.4
shahidriazonline

See private message.

$212.5 USD in 30 dias
(18 Comentários)
4.5
shraddhamit

See private message.

$255 USD in 30 dias
(8 Comentários)
4.2
deepakpaxcel

See private message.

$170 USD in 30 dias
(23 Comentários)
3.7
philmanningvw

See private message.

$191.25 USD in 30 dias
(10 Comentários)
3.1
dancavallaro

See private message.

$204 USD in 30 dias
(4 Comentários)
3.1
greenvalleyvw

See private message.

$243.1 USD in 30 dias
(12 Comentários)
3.0
scriptlancevw

See private message.

$255 USD in 30 dias
(5 Comentários)
1.3
pavelmakhynia

See private message.

$34 USD in 30 dias
(0 Comentários)
0.0
raghuveeravw

See private message.

$170 USD in 30 dias
(0 Comentários)
0.0
elflorinvw

See private message.

$255 USD in 30 dias
(0 Comentários)
0.0