>Ok, so I can truncate rather than drop, but then if I do select into I get an error that the table exists. I guess I would have to use Insert Into Select or such?

Yes.

>
>Also, the first time through the loop I would still need someway to know if the table needed to be created or just truncated and inserted, right?

Right again. You could do the test using OBJECT_ID().

-Mike