Quote:
|
... to create teamporary table with in a stored procedure and running a while loop on the temporary table.
|
In my experience,
many of temporary tables were unnecessary.
(One of exceptional patterns may be sharing the temporary table(s) in multiple procedures.)
I thought same things in your procedure, especially if the process in
the while loop was not so complex.