Error: General ODBC Error: [Microsoft][ODBC SQL Server Driver][SQL Server]Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= - when creating a query through quick letters

Some users experience this error when creating and output query in quick letters:
Error: General ODBC Error: [Microsoft][ODBC SQL Server Driver][SQL Server]Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression. Native error 16945
 
Run the Delete Spouse Plugin: How to download and run the DupeSpouse.exe utility

Steps to Duplicate

1) Create a constituent query
2) Include the query in a Quick Letter
3) Mark to mail to Head of Household only
4) Mark to create output query
5) Click Export

Environment

 Raiser's Edge
 7.94

Was this article helpful?