Views with order by

This is only a problem on SQL 2005 and SQL 2008 without a hotfix: https://support.microsoft.com/en-us/help/926292/fix-when-you-query-through-a-view-that-uses-the-order-by-clause-in-sql