>>>Thank you. I now created a permanent stored procedure (exactly as the temp one) but still the cursor is not updated. I even set the value to be OUTPUT in the stored procedure to some number but the Identity field still shows 0 after update. Could it be that the reason is the Identity field is the same as PK field?
>>
>>Do you have another unique key in the table (as in this sample it's timestamp field)?
>
>No.
May be that's why your code is not working the same way as Aleksey.
If it's not broken, fix it until it is.
My Blog