deleting and reusing a temp table in a stored precedures
- by Sheagorath
Hi
I need to SELECT INTO a temp table multiple times with a loop but I just can't do it, because after the table created( in SELECT into you can't simply drop the table at the end of the loop because you can't delete a table and create it again in the same batch.
so how can I delete a table in a stored procedure and create it again?
here is a…