When you query through a view that uses the ORDER BY clause in SQL Server 2008, the result is still returned in random order

By Frank Kalis