Hello All;
I know this is a bad idea but i am looking at two options
1. using a loop, Create a table dynamically, insert into the table a particular information, then create another table and insert into the other table another information and continue on
2.use a scheduled job to call a procedure that creates a table dynamically, insert into that table, then have the job run again to create another table dynamically and insert into it and continue on
I need to do this because I am running a query that returns 300 billions rows and i am trying to populate the results in several tables containing small chunks to enable the testing of the data.
Thanks in advance..I will work on posting my initial coding attempt shortly