<div>
Better use SSIS for this. Its hard to do the FUZZY lookup using T-Sql<br />
<br />
<a href="http://msdn.microsoft.com/en-us/library/ms345128" rel="ugc nofollow">http://msdn.microsoft.com/en-us/library/ms345128</a>
</div>


Better use SSIS for this. Its hard to do the FUZZY lookup using T-Sql

http://msdn.microsoft.com/en-us/library/ms345128 [http://msdn.microsoft.com/en-us/library/ms345128]

<div>
The problem is I have VS2008 and sql 2005 which inhibits the SSIS to run. &nbsp;Isn't that true that sql 2005 requires VS2005 to run SSIS? &nbsp;Thanks.
</div>


The problem is I have VS2008 and sql 2005 which inhibits the SSIS to run.  Isn't that true that sql 2005 requires VS2005 to run SSIS?  Thanks.

<div>
I was told wrong information before. &nbsp;Thank you very much, it does work. &nbsp;I am able to bring up the BIDS and created a SSIS. &nbsp;Wow, I wasted a month writing various script for cleaning up database when I could just use this. &nbsp;However the link you provided for sql 2005 doesn't seem to follow what I see in my version of BIDS. &nbsp;I cannot follow even the 3rd step of To construct the simplest Fuzzy Lookup package: at the link. &nbsp;I think I will check out the instruction in sql 2008 for this and hope that will work. &nbsp;But much appreciation for your help.
</div>


I was told wrong information before.  Thank you very much, it does work.  I am able to bring up the BIDS and created a SSIS.  Wow, I wasted a month writing various script for cleaning up database when I could just use this.  However the link you provided for sql 2005 doesn't seem to follow what I see in my version of BIDS.  I cannot follow even the 3rd step of To construct the simplest Fuzzy Lookup package: at the link.  I think I will check out the instruction in sql 2008 for this and hope that will work.  But much appreciation for your help.

<div>
Ignore the last post note. &nbsp;It is working as described in the url. &nbsp;My bad. &nbsp;Thansk.
</div>


Ignore the last post note.  It is working as described in the url.  My bad.  Thansk.

<div>
<div class="content wysiwyg-content">
Hi, I'm trying to find possible match between 2 tables based on FirstName and LastName column. &nbsp;If table B has a similar Fristname and similar lastname to that of table A then list it. &nbsp;What's the best way to do this? &nbsp;Thank you.
</div>
</div>


Hi, I'm trying to find possible match between 2 tables based on FirstName and LastName column.  If table B has a similar Fristname and similar lastname to that of table A then list it.  What's the best way to do this?  Thank you.

How to do a fuzzy match to antoher table's column?

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.

Microsoft SQL Server 2005

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.