That what a "quirky update" is about...
But!
To make it bullet-proof you need to read J.Moden article and see what else should be added into your query, so it will always work properly (eg. clustered index and MAXDOP 1).
Otherwise, you may find surprising that sometimes you will end up with unexpected results...