For one of the procedure Upgarde Advisor has thrown this error.
"Non integer constants are not allowed in ORDER BY clause in 90 or later compatibility modes"
Please let me know hoew to solve this
ORDER BY 'MYFullNAME (Last Name/First Name)',A.CreationDate
asked Jun 15, 2010 at 05:06 AM in Default
assuming that your non-integer constant 'MYFullNAME (Last Name/First Name)' is actually a column alias....
replace the non-integer constant with whatever the column is in the select
answered Jun 15, 2010 at 05:53 AM
Kev Riley ♦♦