Msg 408, Level 16, State 1, Line 1
A constant expression was encountered in the ORDER BY list, position %i.
This error message appears, when you try to use a constant expression in the ORDER BY clause.
The T-SQL statement can be parsed, but causes the error at runtime.
Error of the Severity Level 16 are generated by the user and can be fixed by the SQL Server user. The constant expression must be removed.
This error message was introduced with SQL Server 2005.
ORDER BY 1-1
While the use of ORDER BY 1 is syntactically valid, the use of the 1-1 expression raises the error.