Steve Endow has an interesting look at Using ORDER BY in a SQL Server 2005 or SQL Server 2008 View. Like Steve, I usually have to deal with this in ultimate delivery tool be that Excel, SSRS, SmartList Builder, whatever.
Using ORDER BY in a SQL Server 2005 or SQL Server 2008 View
This was originally posted here.
*This post is locked for comments