Hi Herring,

I read with interest on this topic of the 'replacing cursor and while loop'.

I faced the same problem on having lot of cursor which I replace with loop, but didn't solve my execution time.

Your article really help me to look at different way to replace cursor with select statment. I know how to use

select for updating data using select method from your

article.

But I cannot think of any good way to insert new data

using select statement. Do you have any good way to

insert new data using the select statement which I replace

from cursor.

Please advise. thank you