Mark-101232 (2/8/2012)
The non-deterministic behaviour of UPDATE..FROM is well known and fully documented in BOL. There are other non-deterministic functions in SQL Server such as the ANSI compliant ROW_NUMBER - would you ban that as well?
Who is this question directed at Mark?
Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi