Yeah... I forgot that you've been around a long time... didn't even read to see who did the post, Farrell. 

Speaking of being around for a long time, whatcha doin'...

Don't forget... temp tables are tables, too.  You can add indexes...

You also need to make the 2nd line of the format file equal to the number of columns listed in the format file...

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