Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Dealing with Addresses Expand / Collapse
Author
Message
Posted Friday, June 13, 2003 12:00 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: 2 days ago @ 1:30 AM
Points: 2,898, Visits: 1,795
Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnists/dpoole/dealingwithaddresses.asp

LinkedIn Profile
Newbie on www.simple-talk.com
Post #13195
Posted Tuesday, July 1, 2003 3:20 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Tuesday, February 27, 2007 12:21 PM
Points: 342, Visits: 1
This is pretty wierd as I started working on exactly the same kind of project today, and my comapny is also too poor to afford the PAF files ...

I have over 30,000 addresses and need to match them to 10,000 customers. I still need to add the 30,000 and then have a hierarchy of 30,000 including the 10,000 customers. As I match I need to update the address from the 30,000 file ( as that is more accurate).
The 10,000 customers come from a Cache database and are stored in a different format to the 30,000. The 30,000 (when extracted) are actually in a condensed form of the addreses you dealt with (e.g. if the address consisted of 4 fields the Country would be the last, whereas the next address may consist of 7 fields with the Country the last).

I must admit that most of the suggestions where in the idea box already (Great minds eh?) but I hadn't thought of using Soundex, which I am going to look at now. The merging program will be written in C# and I would be extremely grateful if you would consider swapping notes. If you would please contact me.

I'll post any tips I come across,

Steve



Steve Brett



cheers

dbgeezer
Post #66531
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse