Hi.
I am experiancing a problem with SQL Server 2000 store procedure.
The store procedure, which I am working on, supposed to fetch data
from one table, update data and insert updated data back to that
table.
My problem is that when fetch command gets executed, then every raw is
read. I want to make it work in such a way that only selected raws
must be read, but not all. How can I do it?

table. <<

Please post DDL, so that people do not have to guess what the keys,
constraints, Declarative Referential Integrity, datatypes, etc. in
your schema are. You ask people to help you for free, but you don't
give us any specifications we can use, no sample data, and no DDL.
Also it helps to see code if you have to debug it.

Why aren't you just using an UPDATE statement instead of a cursor with
a FETCH?