I think you are missing out something there. The error has got nothing to do with your update statement.
Procedure TR_PromenaAdresnihPodataka, Line 13 Subquery returned more than 1 value
I don't see line 13 there? Are you using this within a procedure (TR_PromenaAdresnihPodataka
)? Is there any subquery related with it?
Looks like I have very less information on this, to help you out. May be you can explain more on what you are trying to do actually.
It works fine for me.
update sheet1 set item_no='****' where item_no='*'
If you are trying this from your Query Analyser, then I assume that you are not selecting/highlighting this update statement (alone) to get it executed, instead all the other statements that you may have tried before and after this update statement are executed to give you that error. Can you check?
- Vijay G
Strive for Perfection