Hi evryone
I have the folowing problem
I have two columns id (varchar 20) and parent(varchar 20) in table adreses

Table has 20000 rows and some values in parent column are *
I want those rows to change to x

So this query works fine:

select parent from adreses where parent='*'

but the updete query return error:
update adreses
set parent='x'
where parent= '*'

This is error:
Server: Msg 512, Level 16, State 1, Procedure TR_PromenaAdresnihPodataka, Line 13
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.

Why???
Thanks

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.
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?

Cheers!

_________________________
- Vijay G
Strive for Perfection

There is no subquery. You are not telling us the whole story.

I'm guessing you are trying to 'simplify' your post, so you've left out a few things, like the fact that either 'x' or '*' is really a subquery, and not a character value. Post the whole query that is failing.

The error is stating that some subquery is returning more than one row (or more than one column) when a scalar value (e.g. Set parent='x') is required.

Jeff Mason
Custom Apps, Inc.
www.custom-apps.com

thanks
The problem was with triger