Distance Between Postal Codes

I'm looking to find out how I'd go about setting up a database where a
visitor to my site could punch in their postal code, and find out how far
they are from another postal code. For example, AutoTrader has this feature
I believe to tell you how far the vehicle is from you. Dating sites have
them so you can do proximity searches.

Anyone have any ideas where I could start? I'm thinking the post office,
but if anyone else has suggestions, I'm open to hear them.

Thanks!Are you in the UK? Royal Mail has some address database products that
may meet your requirements:

http://www.royalmail.com/portal/rm/...40085&gear=shop

Other solutions exist too:
http://www.google.co.uk/search?biw=...yUK%7CcountryGB

--
David Portas
SQL Server MVP
--|||This company does mailing list software with that data in it:

http://www.melissadata.com/Lookups/|||Actually, no, I'm in North America (Canada). Sorry for not mentioning that.

"David Portas" <REMOVE_BEFORE_REPLYING_dportas@.acm.org> wrote in message
news:1120060282.670987.93490@.g14g2000cwa.googlegro ups.com...
> Are you in the UK? Royal Mail has some address database products that
> may meet your requirements:
> http://www.royalmail.com/portal/rm/...40085&gear=shop
> Other solutions exist too:
> http://www.google.co.uk/search?biw=...yUK%7CcountryGB
> --
> David Portas
> SQL Server MVP
> --|||Be aware of the limitations of these calculations. I have done something
similar with US zipcodes, same principle. Each zone has a latitude and
longitude associated with it. This point is known as a centroid which is a
representative point for the whole zone. If the zone is a square or a circle
the centroid would be right in the middle. For a very irregular zone the
centroid might not even be in the zone. Think of a doughnut shaped zone.

Then you calculate the distance between the 2 centroids. Imagine 2 100 mile
square zones side by side. The distance calculation would be 100 miles. The
2 interested parties could actually be across the street from each other
each in their own zone.

Dist Agent Setting

Running Win 2003 & SQL 2005
I had a problem with one of my dist agents & got backed up to the tune
of 1.55 million commands in the distribution database waiting to be
applied.
The agent has been running for 9+ hours and the number of pending
commands has not changed.
Is there a setting I can chang/make in the dist agent to get them to
process faster or atleast see the number of pending go down, so I will
know it is working.
AHIA,
Larry...
Larry - you could try reducing the -CommitBatchSize
nd -CommitBatchThreshold parameters and see if this helps.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com

Displaying Number Format As Per The Regional Settings in Crystal Report

Sir,
I am Using Crystal report 10.
How to Display The Number Format as like The Regional Setting in The computer.
After Changing The Regional Settings, I Changed The Number Format to The System Default Format...But It is Not Working...
Plz Help meHi There,
Can you please let me know if you found solution to this problem? We have the same problem in our reports. We cannot use formula fields as we have close to 60 reports and converts all fields to formula fields would not be possible.
Thanks in advance