Update sub query

[vinci]

hai,
I have using sql2000 server i met one problem in upadate
query.

My table name is reserve

sno. cmname allocated
451 raja no
555 kumar yes
338 prabu no
224 mari no
993 arun no
330 makesh yes

This table having 200 records. I want to update first 20 "no" records
to update to "ye"

i am using this quer

update reserve set allocated='yes' from(select
allocated from reserve where allocated='no')

but this is not come exact answer please help this topic.

Thank u

Regards,
Vincent Manapparai.

[--CELKO--]

Please post DDL, so that people do not have to guess what the keys,
constraints, Declarative Referential Integrity, data types, etc. in
your schema are. Sample data is also a good idea, along with clear
specifications. It is very hard to debug code when you do not let us
see it.

>>This table having 200 records [sic]. I want to update first [sic] 20 "no" records [sic] to update to "yes" <<

Rows are not records; fields are not columns; tables are not files;
there is no sequential access or ordering in an RDBMS, so "first",
"next" and "last" are totally meaningless. If you want an ordering,
then you need to have a column that defines that ordering.

>update reserve

set allocated='yes'
from(select allocated from reserve where allocated='no') <<

Never use the proprietary UPDATE.. FROM.. syntax; the results are
unpredictable.

Want to try again with a usable spec?