Update returning error

[mwa]

I am running the following update satement:

update dbo.SECTION125
set status  = 'C'
where emp_id in (select emp_id from Enrollment_Confirmation)

And I get the following error:

"Subquery returned more than 1 value. This is not permitted when the subquery follows =,!=,<,etc."

I've never had a problem doing similar updates in the past. I've only seen this error when the "set" relies on a subquery that returns multiple records. In this case, the "set" is hard coded to 'C'. Anyone have ideas why this is not working?

mwa
<><

 

[SQLDenis]

yes, you have a trigger on the table which is not coded correctly and does not handle multi row updates

run this to get the triggername


EXEC sp_helptrigger SECTION125


Denis The SQL Menace
--------------------
SQL Server Code,Tips and Tricks, Performance Tuning
SQLBlog.com, Google Interview Questions

 

[gmmastros]

My best guess is that you have a 'mis-behaving' trigger. To see what triggers exist on the table...

sp_helptrigger 'Section125'

My guess is that there is at least one trigger where 'IsUpdate' = 1. Furthermore, my guess is that the trigger was written to ONLY accommodate 1 row being updated at a time.

-George

"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom

 

[mwa]

That was the problem. Thanks!

mwa
<><