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
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