I'm trying to execute the following:
WHERE STATE_CODE5 IN ('IL','NV','VA','NH','HI')
WHERE STATE_NAME8 = 'HAWAII'
ORDER BY STATE_CODE5;
In both 2005 and 2008 versions of the SQL Server the query parses ok, but on execute I get the following error:
Msg 0, Level 11, State 0, Line 0
A severe error occurred on the current command. The results, if any, should be discarded.
If I remove the the 'ORDER BY' clause, I am able to execute the query with no problem.
I've searched the forum and I know this error comes up often in various circumstances, however I didn't see anything similar to this. Please advise, maybe I'm writing the query incorrectly? Thanks
View Complete Post