I have a script which create a temporary table:

#TABLE1

Then a script is run which sends data to an output file and when the script completes i drop the temporary table...