Subject Selects and Updates based on sub-queries
Author sean_brad

I'm using values in a temporary table as a means to select rows from
a main table, as in the example below:

update Table1 set Flag = -1 where RecNumber in
(select RecNo from Temp_Table)

However when I run this query it does not seem to terminate, and the
IBServer process processor usage goes up to 99% even when there are
very few
rows in the temporary table.

Is there a better way to write this type of query or could there be
something wrong with my Server setup?

Thanks in advance,