Record Matching Software to Compare two tables and match on % Based

Posted by Crazyd on Super User See other posts from Super User or by Crazyd
Published on 2012-09-27T03:14:47Z Indexed on 2012/09/27 3:40 UTC
Read the original article Hit count: 194

Filed under:

sql-server

|

programs-and-features

So I have some table with Name, Address, and Zip with no record data attached; and I have a table which has all the same, but has more information and I need a way to merge the tables when they don't match 100%.

How do I match them up if they aren't Identical? I'm a newb @ SQL, but I know they won't match up for the most part and I can't be the only one with this issue. However software which will do this has proven to be difficult.

Writing software to do this would even be worse than having to do it in the first place.

I know I can do this in excel; kinda, but with the amount of records I have its proving to be difficult over a million.

© Super User or respective owner

Related posts about sql-server

SQL SERVER – Beginning SQL Server: One Step at a Time – SQL Server Magazine

as seen on SQL Authority - Search for 'SQL Authority'
I am glad to announce that along with SQLAuthority.com, I will be blogging on the prominent site of SQL Server Magazine. My very first blog post there is already live; read here: Beginning SQL Server: One Step at a Time. My association with SQL Server Magazine has been quite long, I have written nearly… >>> More
How to install SQL Server 2005 Configuration Manager without installing SQL Server Management Studio

as seen on Server Fault - Search for 'Server Fault'
Hi, I need to configure SQL Server aliases on a public-facing production server. To do that, I need to install SQL Server Configuration Manager. I was not able to find a standalone installer for that, so I am having to install SQL Server 2005 Client Components. This approach is not ideal as we don't… >>> More
[MAJ] SQL Server 2005 Express Edition - La version gratuite de SQL Server 2005

as seen on ASP-PHP.net - Search for 'ASP-PHP.net'
Modification technique pour le site de l'article. >>> More
How to create SQL Server Express DB from SQL Server DB

as seen on Stack Overflow - Search for 'Stack Overflow'
I have a SQL Server 2008 DB. I want to extract SOME tables (and associated schema, constraints, indexes, etc) and create a SQL Server Express DB. It isn't a sync of the target, we stomp on it. We ONLY need to do this in the file system (not across the wire). We are not fond of the synchronization… >>> More
sql server 2000 error, error trying to connect to sql server 2005

as seen on Stack Overflow - Search for 'Stack Overflow'
i am connecting to sql server 2000 on a remote computer with a dotnet application, but when i try to open the connection it gives the following error: When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections What… >>> More

Related posts about programs-and-features

Win7 - Opening "Programs and Features" as Admin from command line (logged in as regular user)

as seen on Super User - Search for 'Super User'
We have Win7 machines on a domain that we'd like to open the "Programs and Features" control applet via the command line while a regular user is logged in. Heres the catch: I know how to do this using runas from command line BUT after "Programs and Features" opens, I dont truly have the ability to… >>> More
How To Remove A Broken Program From the Programs and Features List In Windows 7?

as seen on Super User - Search for 'Super User'
On a Windows 7 64-bit desktop, there is a program on the Programs and Features list (Control Panel\All Control Panel Items\Programs and Features) that refused to uninstall. The error obtained is: Error 1723. There is a problem with this Installer package. A DLL required for this install to complete… >>> More
Bluetooth Connectivity that an error

as seen on Super User - Search for 'Super User'
I have a bluetooth USB, every time I enter the bluetooth, bluetooth is active only a few seconds, after which it can not be used again In 'devices and printer' there is still a bluetooth but if you want to save the settings it can not, there are error message or bluetooth is revoked. I am using… >>> More
What software can I use to get statistics about the programs I use most? [closed]

as seen on Super User - Search for 'Super User'
I am looking for software that reports statistics about my program usage over time. It should display output something like this (numbers are made up): Program usage today: Youtube (Chrome) 42:10 9.42% NetBeans 30:52 6.33% Google search (Chrome) 12:03 3.20% Windows… >>> More
Are there any program for showing tooltip via OCR

as seen on Super User - Search for 'Super User'
Edited for clarification based on comments: At work we have an old developed program where I need to navigate on a very long dropdown list only with numbered codes. To select the correct code, I manually look at an excel list that shows the code and the name each codes corresponds with. To make… >>> More