In SQL Server 2000, you can do something like:
Create view myView as select top 100 percent column1, column2 from mytable order by column1
to allow for ordered views. It isn't 'supposed' to work, but it does.
It doesn't in SQL Server 2005. However, this does:
Create view myView as select top 99.9999999999999 percent column1, column2 from mytable order by column1
If you count, there are 13 decimal places. If you add a 14th decimal place it doesn't work.
Go figure.
http://sqladvice.com/blogs/repeatableread/archive/2006/06/14/18682.aspx