if this is to get around the issue of "CANNOT USE ORDER BY IN A VIEW WITHOUT TOP CLAUSE", use

SELECT TOP 100 PERCENT

[...]

ORDER BY [...]

two additions (to a useful list):

1. SQuirreL - a true multi platform SQL Client. Supports SQL Server, Oracle, Access, MySQL, Firebird, PostgreSQL, Sybase,Informix, Excel, text files, and more....from ONE interface....