you could try writing a stored procedure that looks something like this.(I have used the table datatype. you could use a temporary table if u want.)

-------------------------------------

create procedure update_active_operation

...