Posted by Marcin A. Guzowski on 06/29/07 21:04

paulmac106@gmail.com wrote:
> 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?

That's not an issue - it's pure ignorance. Probably someone assumed,
that only one record can be updated at a time. Trigger logic (if the
trigger is causing this error) must be changed to handle true set-based
operations.

--
Best regards,
Marcin Guzowski
http://guzowski.info

[Back to original message]