>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