La clausola ORDER BY non è consentita in viste, funzioni inline, tabelle derivate, subquery ed espressioni di tabella comuni a meno che non sia specificata anche la clausola TOP o FOR XML.
Click to search this error in Google
English version
The ORDER BY clause is invalid in views, inline functions, derived tables, subqueries, and common table expressions, unless TOP or FOR XML is also specified.
SQL Server