SG,

Man, Serqiy is right and Celko would have fun this this one... Why are you splitting an attribute into separate tables?  What is it that you are trying to do that...

Just on the outside chance you didn't know... you do realize that SQL Server must be installed on a Windows Server? (Except for the Developer's Edition, of course)?

Thanks for the tip, Serqiy... if I ever let my guys put text in the database, that'll help a lot.

There are tons of possibilities including exclusive locks and deadlocks that will cause almost instant timeouts... The use of sp_Lock followed by the use of sp_Who2 for the offending SPID...

Yep... I agree with that...

I guess that doesn't even matter...

Whatever you use to uniquely identify a CDR with (1 column or multiple columns), here's what I'd do...

First, I just don't understand the need for...

Yep, I understand what you are doing... I just don't know why...

sp_Recompile 'tablename' will (from Books Online) recompile the stored procedures and triggers that use the object to be recompiled the next...

Crud, I asked the wrong question...

If the CDRFingerPrint is duplicated, does that give an indication that the same CDR is in the temp table more than once? 

Because it's just as easy to make a parallel table and still enjoy all of the benefits of the various string functions (if you need them, someday) that you can use...

Very nice, Joe... when do they hit the streets?

Eric, your current code misses an overlay... see line 8 below...

First of all, let's draw a picture of everything that has a start date less than the end date and...

Good lord, don't use a text column.  If you have to, put a VARCHAR(8000) in a parallel table with the same key...  you're asking for a world of hurt when...

Actually, it does... but you must include the object owner as the object name... in other words, you have to use the 2 part naming convention when changing the ownership...

Thanks for the feedback on this, Doanthi...

I don't know what it is but I've never had the speed problems with "Select Into" that so many have spoken about.  It is...