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

    user9294681

      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