Thanks alot that great. I hadnt come accross this ieda before. Interesting that it uses set operations but relies on the fact that the record sets will be processed row...
Yep the the lock will remain untill the preocess trigger is completed. You could use the trigger to insert relevant rows into a table and then use a scheduled job...