When trying to execute an update statement in the editor (update users set isactive=0 where UserId < > 104), I get the following error message...
"Lookup Error - SQL Server Database Error: Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, < , < = , >, >= or when the subquery is used as an expression."
,
Issue caused by trigger on table being updated.
Disable the trigger on the table that is being updated and run the statement.
This is not an issue with Toad. The same error would be received if the statement is run in Query Analyzer.
