Click to See Complete Forum and Search --> : Don't know whats wrong


Wej
06-12-2008, 03:04 PM
Here is the MySQL Query
UPDATE tbl_Cust_Main SET paralegalID = 286 WHERE paralegalID = 67 AND casestatusid != 2;

It returns:
"Server: Msg 512, Level 16, State 1, Procedure tr_InsertCustPriceForUpdate, Line 6
Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.
The statement has been terminated."

I am not sure what that means.

Thanks for any help

legendx
06-12-2008, 05:11 PM
It appears the error is being generated from a stored procedure, or trigger, and not your query.

"Server: Msg 512, Level 16, State 1, Procedure tr_InsertCustPriceForUpdate, Line 6

Take a look there for your problem