Error: Error loading grid: General ODBC Error: [Microsoft][ODBC SQL Server Driver][SQL Server] ORDER BY items must appear in the select list if the statement contains a UNION, INTERSECT, or EXCEPT operator

When searching for constituents using a search query that contains either of the Sort fields of Name or First Name, users will receive the following error:

Error loading grid: General ODBC Error: [Microsoft][ODBC SQL Server Driver][SQL Server]ORDER BY items must appear in the select list if the statement contains a UNION, INTERSECT or EXCEPT operator.
Native error: 104
[Microsoft][ODBC SQL Server Driver][SQL Server]ORDER BY items must appear in the select list if the statement contains a UNION, INTERSECT or EXCEPT operator.
Native error: 104
[Microsoft][ODBC SQL Server Driver][SQL Server]ORDER BY items must appear in the select list if the statement contains a UNION, INTERSECT or EXCEPT operator.
Native error: 104
[Microsoft][ODBC SQL Server Driver][SQL Server]The cursor was not declared. Native error: 16945
Download and install the latest version and patch, if applicable. 

Alternate Solutions:

Environment

 7.92.5473
 7.92

Was this article helpful?