Thanks, but I want to put the result in a variable within the stored procedure; not just display it. BOL doesn't say anything about that.

I have no idea how efficient that is but its an amazingly innovative solution!

Not exactly what you want - and not exact(!) - but have you considered using SOUNDEX()?

If you need all fields, you could identify the tables that are generating the duplicate results and put these into a subquery, performing the DISTINCT there. Then join the...

One other possibility is that production is mutliprocessor and development is single processor. If you have table variables, you can have problems in a multiprocessor environment as they don't...

This might help :

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

Saving keys anywhere in any form introduces some vulnerability ... but you can make it difficult for an attacker by making it as unobvious as possible - embed it in...

You could try using the Levenshtein edit distance - there are plenty of examples on the net. You would have to write your own function for this but it...

I assume that you are connecting via ADO. Check the ADO errors collection - that will record anything that goes wrong communicating with the server but will not generate...

The MSDN download site lists everything that you have to uninstall in the required order.

You need to use the ADODB AppendChunk method. I believe that you cannot pass parameters longer than 8060 bytes.

Julian, thanks but no success.  SQL Server Express Manager comes up with a modal connection dialog which won't recognise any combination of computer and server names.  The Cancel button kills...

A masterly understatement! 🙂

It looks like its to do with MS Query but I can't help you there. If you don't get a reply from someone else in this...

Something like :

CREATE TABLE dbo.Test (Param1 DateTime NULL, Param2 DateTime NULL)

INSERT INTO dbo.Test (Param1, Param2) VALUES (?, ?)

This assumes that your parameters are DateTime data type. If they are...

I think we're into debugging here. Can you write a script to put the passed parameters into a test table so that you can be sure of what's coming...