1 2 Previous Next 15 Replies Latest reply on Sep 12, 2019 5:12 PM by user9294681

    using a loop to create  a table dynamically and inserting rows into it


      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

        1 2 Previous Next