Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
kshah82
Starting Member
1 Post |
 Posted - 2009-08-19 : 23:10:29
|
| I have two tables. Both tables have customer names and City and Zip info. There are no unique keys in this table so I have to match on strings from both tables. To make the situation difficult, the names of customers are not one for one match i.e.Table AK JewelersTable BK GOLD JewelersIn this situation the customer is possibly the same customer, so I need to look at the City and Zip and if it matches then I need to write out this record to a table for closer inspection.Please can anyone help? |
|
|
Mangal Pardeshi
Posting Yak Master
110 Posts |
Posted - 2009-08-20 : 02:30:39
|
| I think SSIS is best bet for you. You can use Fuzzy Look up transforation to achieve this.Mangal Pardeshihttp://mangalpardeshi.blogspot.com |
 |
|
|
|
|
|
Closest Matching