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
SQL & DataInstall, Upgrade & Admin
Archived post from 2010. Dynamics GP and the links it points to have changed since; check current documentation before relying on version-specific steps.