quote:

---

DECLARE @iTest_Id int
DECLARE @sFname varchar(10)

CREATE TABLE #test (
test_id int not null
, fname varchar(10) not null )

INSERT INTO #test values ( 1, 'Bob' )
INSERT INTO #test values ( 2, 'Sue' )
INSERT INTO #test values ( 3, 'Martha' )

DECLARE curTest CURSOR
LOCAL DYNAMIC
FOR SELECT test_id, fname
FROM #test
ORDER BY test_id
FOR UPDATE OF fname

OPEN curTest

FETCH FIRST FROM curTest
INTO @iTest_Id, @sFname

WHILE @@Fetch_Status = 0
BEGIN
UPDATE #test
SET fname = 'DELETE'
WHERE CURRENT OF curTest

FETCH NEXT FROM curTest
INTO @iTest_Id , @sFname
END

CLOSE curTest
DEALLOCATE curTest

---