A long, long time ago in a galaxy you can reach out and touch right now, ORDER BY in a VIEW meant something. If you had a view like the following: CREATE VIEW dbo.RubbishAS    SELECT TOP 100 PERCENT Trash        FROM ...