I'm wondering if anyone may be able to assist with the following query.
I'm attempting to update a single value on a table for a number of rows.
The select query returns the data I desire and takes the form...
This returns all the rows I would like to update. Within the table there is a column called Status which I wish to change from 0 to 1 on all selected rows.
So I've changed the above to a update statement and added the Status condition.
The query churns away for a while, then returns the following error message.
I'm struggling to see why this error occurs when my select statement returns the data I want. I sense it has something to do with when it mentions trConditionComponentHistory but I've no idea where this is comding from.
asked Dec 06, 2011 at 03:56 AM in Default
I'm willing to bet that trConditionComponentHistory is a trigger on the table you are trying to update, and it's been coded to expect only one row at a time will be updated.
answered Dec 06, 2011 at 04:13 AM
Kev Riley ♦♦
It looks like you have a trigger on the table you are trying to update on.
Run the following query to find out what trigger is on that table:
You will see the name and the definition of the trigger. I am guessing tha the trigger calls the stored procedure
answered Dec 06, 2011 at 04:17 AM