Hi All:
I am trying to update one of the filed in my sql table. I need to update only one row in this table.

this is my code

Set RowCount 1

Declare @ActID Varchar(15)
Declare @TranAmt Money


Declare TableCursor Cursor For
Select Activity_ID,Tran_Amt From QW2_ROLLUP_TABLE GROUP BY ACTIVITY_ID, TRAN_AMT

Open TableCursor
Fetch Next From TableCursor into @ActID,@TranAmt
While @@Fetch_Status = 0
Begin
UPDATE QW2_ROLLUP_TABLE
SET New_Tran_Amt = @TranAmt
Where Activity_ID = @ActID
End
Close TableCursor
Deallocate TableCursor

When this finish executing, none of the row in this table is updated. Please tell me what am I doing wrong?
Thanks