>>Select your data as CTE (common table expression) and then update based on it - it would be easier to debug,
>
>The situation has been resolved earlier on.
This advice would help you to find source of such problems with more ease in a future.
If it's not broken, fix it until it is.
My Blog