I prefer to avoid SQL Server cursors and use set based solutions. You can create a temp table or table variable with two fields ActID Varchar(15) and TranAmt Money and insert result of select into it. After that you can update QW2_ROLLUP_TABLE with one UPDATE comand by joining the table to the temp table or table variable create before that.


> 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
>
<snip>