In SQL Server 2005, if you create a view utilizing the TOP (100) PERCENT and ORDER BY clauses, you will not get back your results in the order specified. Example: USE AdventureWorksGOCREATE VIEW CustomersOrderedbyTerritoryASSELECT TOP(100) PERCENT *
Read More