UPDATE tb_comments

SET user_id =

(SELECT id_tb_comments, tb_users_crm.id_user

FROM tb_comments

INNER JOIN tb_jobs ON tb_comments.job_id = tb_jobs.id_tb_jobs

INNER JOIN tb_school ON tb_jobs.school = tb_school.id_tb_school

INNER JOIN tb_portfolio ON tb_school.folio_id = tb_portfolio.id_tb_portfolio

INNER JOIN tb_users_crm ON tb_portfolio.id_tb_portfolio =...

Ok... here we go... let's NOT do it on the BULK INSERT side... let's do it where you tried to insert into the daily feed file from the temp table...

That's why I did a test on 10 million records... your chunks will be easy.

Your temp table load is fine...

I've suggested it 3 times now, John... for the temp table...

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...