Comparing Strings (Advanced Soundex)

Hello,

I need to compare movie names from two systems. In both systems these names are entered manually by operators. I would like to compare them and give a rating on how close these names are equal.

Stripping special characters, and spaces is just not enough. It can happen that they key in sligthly different names. I've tried to use soundex but as we have over 15000 movie titles over the years i'm getting to many equal soundexes to use this as a comparison key.

Any ideas if there are techniques to do this ...

Kind Regards

See if these will help you out any:

http://www.sqlservercentral.com/columnists/mcoles/sql2000dbatoolkitpart2.asp

http://www.sqlservercentral.com/columnists/mcoles/sql2000dbatoolkitpart3.asp

Comparing Records

Is there a Stored Procedure that compares 2 records and give you the
diffrences between them? Or do I have to manually compare each record?You will have to write one depending on what you want to compare and how you
want to retrieve the differences. For direct data comparison there are
certain 3rd party tools from companies like RedGate which you can buy off
the shelf.
Anith|||I wanted to do this from a trigger. ie see what changes there are from
the old record to the new record.|||You'd have to use the inserted and deleted tables within the trigger to do
this. Check out the topic CREATE TRIGGER in SQL Server Books Online; there
are certain examples which details how you can use them.
If you still have difficulty in coming up with a required solution, pl.
refer to www.aspfaq.com/5006 and post required information for others to
repro your problem.
Anith|||Thanks, I know how to do triggers. But you answered my question so
thanks.

Comparing data in table with validation table

Hi all

I have a customer table with a postcode and a suburb fields and cutomer info which is manually entered by data entry people...

I am trying to compare the entries against a postcode table with the correct postcodes which have fields postcode and suburb and based on the postcode entered in the customer table it should be the same as the suburb in the postcode table, if they are not the same output them to a table for manual checking..How would I go about this

thanks

You could do something like:

select *

from yourtable

where not exists (select *

from postCode

where postCode.postCode = yourTable.postCode)

etc.

As an aside, I would probably consider having a transition phase where you have a table for data entry, then a table that houses the final data, so you never have bad values in your actual OLTP database, just in the transition data, which you would delete in the process of putting it in the main table.

|||Would the above work if the postcode table contains all possible postcodes but the customer table may contain 1000 off the possible 16000 postcodes.|||

Well, yeah, but you need to be able to form the set of 1000 possible rows that are legal and use it in the EXISTS rather than all rows. So something like:

select *

from yourtable

where not exists (select *

from postCode

where postCode.postCode = yourTable.postCode

and meets1000criteria = 1)

Or you could build a view for the valid postalCodes.

command window open when SQL agent start

When i start mssqlserver service, it do not start SQLAgent
It is listed in the dependancies of both
when i start the sqlAgent manually, there is a command window that opens up with nothing in it, just the cursor blinking, BUT everything runs fine, the msssqlServer and the SQLAgent are both running
if i close that window, SQLAgent stop, and naturally, the connection to the DB is lost as well.
This never use to do that before
?
Thanx
************************************************** ********************
Sent via Fuzzy Software @. http://www.fuzzysoftware.com/
Comprehensive, categorised, searchable collection of links to ASP & ASP.NET resources...
You need to check the configuration for the service. Go to
Services(from Control Panel or Administrative Tools -
depending on your OS).
Go to the sqlserveragent service and view the properties for
the service. Select the LogOn tab and make sure to uncheck
the "Allow service to interact with desktop" checkbox.
-Sue
On Wed, 23 Jun 2004 07:51:56 -0700, korivo
(mathieu_corriveau@.hotmail.com) wrote:

>When i start mssqlserver service, it do not start SQLAgent
>It is listed in the dependancies of both
>when i start the sqlAgent manually, there is a command window that opens up with nothing in it, just the cursor blinking, BUT everything runs fine, the msssqlServer and the SQLAgent are both running
>if i close that window, SQLAgent stop, and naturally, the connection to the DB is lost as well.
>This never use to do that before
>?
>Thanx
>************************************************* *********************
>Sent via Fuzzy Software @. http://www.fuzzysoftware.com/
>Comprehensive, categorised, searchable collection of links to ASP & ASP.NET resources...

command window open when SQL agent start

When i start mssqlserver service, it do not start SQLAgent
It is listed in the dependancies of both
when i start the sqlAgent manually, there is a command window that opens up
with nothing in it, just the cursor blinking, BUT everything runs fine, the
msssqlServer and the SQLAgent are both running
if i close that window, SQLAgent stop, and naturally, the connection to the
DB is lost as well.
This never use to do that before
?
Thanx
****************************************
******************************
Sent via Fuzzy Software @. http://www.fuzzysoftware.com/
Comprehensive, categorised, searchable collection of links to ASP & ASP.NET
resources...You need to check the configuration for the service. Go to
Services(from Control Panel or Administrative Tools -
depending on your OS).
Go to the sqlserveragent service and view the properties for
the service. Select the LogOn tab and make sure to uncheck
the "Allow service to interact with desktop" checkbox.
-Sue
On Wed, 23 Jun 2004 07:51:56 -0700, korivo
(mathieu_corriveau@.hotmail.com) wrote:

>When i start mssqlserver service, it do not start SQLAgent
>It is listed in the dependancies of both
>when i start the sqlAgent manually, there is a command window that opens up
with nothing in it, just the cursor blinking, BUT everything runs fine, the
msssqlServer and the SQLAgent are both running
>if i close that window, SQLAgent stop, and naturally, the connection to the
DB is lost as well.
>This never use to do that before
>?
>Thanx
> ****************************************
******************************
>Sent via Fuzzy Software @. http://www.fuzzysoftware.com/
>Comprehensive, categorised, searchable collection of links to ASP & ASP.NET resourc
es...