> > Obviously that doesn't make sense given your example, so I'm wondering if you did a single-row update some time before step 3.
>
> Hi Jim. No, there were no other updates. I'm glad you agree this is strange.
Using my test case in the last email, can anyone explain why this is actually working "as designed"? It's probably not a big issue, but it's a corner case that's still bugging me.
Cheers,
Greg.