SQL Server Error : 116, Severity: 15. Only one expression can be specified in
SQL Server Error : 116 Details
SQL Server Error: 116 Severity: 15 Event Logged or not: No Description: Only one expression can be specified in the select list when the subquery is not introduced with EXISTS. Severity 15 Description: Indicates syntax errors in the Transact-SQL command.
Example:
SELECT [ID], [Date], [Description], [Count] FROM [dbo].[Order] WHERE [ID] NOT IN (SELECT [ID], [NumberofStock] FROM [dbo].[Stock]) Msg 116, Level 16, State 1, Line 4 Only one expression can be specified in the select list when the subquery is not introduced with EXISTS.
This error usually occurs when a sub-query is used in conjunction with the IN or NOT IN logical operator. The IN logical operator checks to see … Read the rest