p.s. Almost forgot... (pardon the soapbox, please) if you get into the habit of writing setbased code that will handle more than 1 row at a time, you've also solved...

Dang... sorry Eric... got so tied up in the theory of it all, I forgot to demo how to do it set based...

Most of the SELECT list in the code...

If that's the case... I'd just drop both tables and the related keys and start them over... but, unless it's for repopulating tables for testing purposes, I'd still like to...

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