I have made a trigger on an insert from table 1.
This trigger is calling a stored procedure. From table 1 I need some values to
pass to the sp. How can I store these values in the trigger and pass them to
In the stored procedure I have made an update for table 2 and I need the
values that are coming from the trigger.
The trigger is working and the sp also but the sp is updating every field in table 2
and not the field with the value that was updated in table 1.