correlated subquery and UPDATE 1

[petperson]

any idea why this:

update individual
set referenceid = 11
where individualid in (select refid from ref_temp2)

would generate the following error:
Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <= , >, >= or when the subquery is used as an expression.
The statement has been terminated.

thx

 

[SQLDenis]

sure, you have a trigger on that table with bad code
in the trigger you have the classic trigger n00b code which looks like this

set @Var = Name from inserted


remember triggers fire per statement not per row

show the trigger code and we might help you correct that

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

 

[petperson]

trigger was the problem..thanks for pointing it out.

 

[ESquared]

lol star for dennis

[COLOR=black #e0e0e0]For SQL and technical ideas, visit my blog, Squared Thoughts.[/color]

 

[ESquared]

er I mean Denis

[COLOR=black #e0e0e0]For SQL and technical ideas, visit my blog, Squared Thoughts.[/color]