I have a query that creates about 30,000 records each time. I would like to dump the results into a temp_table with a timestamp. The query will run once a week and the results will be appended to the temp_table each time with a timestamp
How would I go about creating this temp table?
Thank you for your help