Mass Update on Table with Trigger

From: paulmac106@xxxxxxxxx
Date: Fri, 29 Jun 2007 13:20:04 -0700

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

.

Follow-Ups:
- Re: Mass Update on Table with Trigger
  - From: Erland Sommarskog

Prev by Date: Re: Output Column names in each Row along with the row Value
Next by Date: Re: XML INTO SQL
Previous by thread: Connecting to SQL 2005 using VB6
Next by thread: Re: Mass Update on Table with Trigger
Index(es):
- Date
- Thread

Relevant Pages

Triggers
... In the table designer I gave the procedure name 'InsUpdAccountMasterTrigger' in the Insert and Update Trigger. ... Then I created the procedure in the stored procedure with the following code ...
(microsoft.public.fox.helpwanted)
Re: Mass Update on Table with Trigger
... an update trigger (which updates the field whenever a ... As a result I'm getting an error: "Subquery ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ... Books Online for SQL Server 2005 at ...
(comp.databases.ms-sqlserver)
problem updating view with instead of trigger
... I have created wv_details view that has an instead of update trigger. ... So I changed this query as shown below. ... image data types are invalid in this subquery or aggregate expression.". ...
(microsoft.public.sqlserver.programming)