What are the alternatives for an ORDER BY clause in a View?
Only the outermost ORDER BY will guarantee order


Any intermediate or internal ORDER BY is ignored.This includes ORDER BY in a view
There is no implied order in any table
There is no implied order from any index (clustered or not) on that table


Links


"Sorting Rows with ORDER BY" (MSDN)



  ORDER BY guarantees a sorted result only for the outermost SELECT statement of a query. For example, consider the following view definition: (and example follow that matches this question)