Hello,

Thank you for your help.

The reason for the update 1 is because the process is selecting an item to work on and I only want it to take one at once. Is there a better way?

Thanks for the advice on the none SARGABLE query, I had forgotten that.

Thanks

Andrew