Re: Select and update at the same time (with selected value)?

[Kevin K]

Thanks for the reply Barry.

Perhaps some small background info is needed.

SERVER A: Selects then updates pool_process, setting server_id = "A" where...

SERVER B: Finds pool_process is empty and sleeps again

SERVER C: Selects the SAME record server A did and then updates pool_process, setting server_id = "C"...

The server sleep intervals are constant at 2 seconds but clearly there needs to be a better way of ensuring NO two servers get the same row.