Your humility is surpassed only by your good nature, John.  Well done.

The only time you can do something like what you ask automatically is during the BCP process where you...

Do a search for "aux calendar table" and "auxillary calendar table" on this site and Google... you'll find lot's of examples on how to make a calendar table.  Most things...

The point is, Mark, instead of having to read through the code to find what you want, you only have to lightly scim through the comments to find out what...

Outstanding!  That's just what I was looking for!  Thank your for the help, Aaron.

Thanks, Colin,

Yeah, my problem with "just a case of trying" is we don't have it, yet... they keep threatening me with the offer of the Developer's Edition but I don't...

I guess I don't get it... if Table A is referenced by Table B, it would appear that Table A is a parent of Table B.  Why would you want...

How true... fortunately, I have DBA's that do notice the difference but it's good to check.

Having a calendar table would certainly assure correctness.  If you can do that, that would probably be the best way to go...

Correct... SQL Server's UPDATE statement is one of the more useful ones in that it actually has TWO from clauses that are specifiable... most people leave out the first FROM...

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