The ORDER BY clause in views, derived tables, inline functions, and subqueries in SQL Server 2000

When you use the ORDER BY clause in a view, an inline function, a derived table, or a subquery, you must also specify a Top operator. If you try to use an ORDER BY clause and you do not specify a Top operator, the following error may be returned to the client: Server: Msg 1033, Level 15, State 1

Read More - Register for Free Membership