For a looping concept, i had done a query in recursive but i dont know how to load the result to another table,
I need your help to load the answerset to another table.
All the columns selected at the end of recursive query are inserted in the table. If you want to insert some specific columns then select only those ones.
We were just saying the other day that when you find an answer from Dieter you know you've got something that will work. After a half-hour of trying to figure out the problem with my first INSERT INTO with a CTE I found this lovely concise example and now have data in my table. Thanks again.