“Microsoft SQL Native Client (0x80004005)
Subquery returned more than 1 value. This is not permitted when the subquery
follows =, !=, <, <= , >, >= or when the subquery is used as an expression.”
In T-SQL, this error will occur if more than one value is assigned to a variable.
Only one record can be assigned to a variable at a time. We usually get this error when we want to assign a query result to a variable. In such cases, make sure that the number of rows returned is not more than 1.