When you query through a view that uses the ORDER BY clause in SQL Server 2008, the result is still returned in random order posted on Sep 1, 2010 von Frank Kalis in Links
FIX: The result may be sorted in the wrong order when you run a query that uses the ORDER BY clause to sort a column in a table in SQL Server 2000 posted on Aug 13, 2010 von Frank Kalis in Links
The ORDER BY clause in views, derived tables, inline functions, and subqueries in SQL Server 2000 posted on Aug 13, 2010 von Frank Kalis in Links