Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
acko
Yak Posting Veteran
52 Posts |
 Posted - 2004-06-28 : 08:25:17
|
| Hi evryoneI have the folowing problemI have two columns id (varchar 20) and parent(varchar 20) in table adresesTable has 20000 rows and some values in parent column are *I want those rows to change to xSo this query works fine:select parent from adreses where parent='*'but the updete query return error:update adresesset parent='x'where parent= '*'This is error:Server: Msg 512, Level 16, State 1, Procedure TR_PromenaAdresnihPodataka, Line 13Subquery 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.Why???Thanks |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2004-06-28 : 08:30:38
|
| You have a trigger on the table which does not cope with multi-row updates.Either disable or fix the trigger.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
acko
Yak Posting Veteran
52 Posts |
Posted - 2004-06-29 : 02:43:53
|
| thans a lotalex |
|
|
|
|
|
|
UPDATE problem