Hello Steve!

I've nearly the same problem with collation. I've had to build a "data warehouse" from four different different databases of four systems, one of them is multilingual.

The solution slightly...

Hey Eddie!

I like this conversation very much!

Try this with only 100.000 recs!

if object_id ('tempdb.dbo.#TimeTrial') is not null drop table #TimeTrial

create table...

Excuse Me!

Maybe my english is poor (or too short), I'm from Hungary.

I mean "looping" --> looping...

-- Try to use this FUNCTION instead of any temptables, looping, dinamyc SQL and so on.

if exists (select * from dbo.sysobjects where name = 'f_hextostr' and xtype...

-- With exact parameters:

SELECT *

FROM orders

WHERE ISNULL(@ordernumber,ordernumber)=ordernumber

  AND ISNULL(@ClientName,ClientName)=ClientName

-- In case of using "LIKE"

SELECT *

FROM orders

WHERE ISNULL(@ordernumber,ordernumber)=ordernumber

  AND ClientName LIKE ISNULL(@ClientName,ClientName)+ '%'

-- Test Your solution for SPEED !

R.Dragossy