Posted by paulmac106 on 06/29/07 20:20

Hi,

I need to update a field in about 20 records on a table. The table has
an update trigger (which updates the [lastedited] field whenever a
record is updated). As a result I'm getting an error: "Subquery
returned more than 1 value.", and the update fails.

Is there a way in the stored procedure to handle this issue?

thanks for your help.

Paul

• Next in forum: Re: Mass Update on Table with Trigger
• Prev in forum: Re: Output Column names in each Row along with the row Value
• Thread view: Mass Update on Table with Trigger

[Reply to this message]