I have a loop that adds the values ​​into a table from a store procedure that I use in a select.
The SP can return one or more rows. t_rownr tells which row it is. It always starts at 1.This is working properly.
The problem is that I have a loop that is outside it. If ct_max value is greater than 1, it shall repeat the select and insert. This is where the problem comes.
My select returns the same value, but I want it to increase t_rownr each time the loop is executed.