Trigger problems

[sguslan]

I wrote an update/insert trigger that takes the value in some columns of the inserted table, run an extended stored procedure to do codepage conversion, then tries to update the affected columns. I am so far unable to update correctly without writing a cursor into the trigger. I get sql 24000 wrong cursor state if i remove the cursor.

Any help ?

 

[sguslan]

Let me re-phrase :

Is there a way to make an update/insert trigger work on per ROW basis rather than once per the firing SQL statement ?