ORDER BY in an UPDATE is only possible in a subquery and then you would have to use TOP.
All that not-with-standing, I wish the OP would post some data and table definitions. It would make it easier for us all to answer the post.
--Jeff Moden
Change is inevitable... Change for the better is not.