Need a trigger to run a stored procedure after insert in specific table, if inserted in a specific field a certain value. For example, have a table of movement and need to be executed a stored procedure when a value is inserted in a specific field. The stored procedure executes movements on all the records from a table, only interests me running on the records containing the value entered in a field in the first table. I hope I have been explicit, thank you for your help.
I need a trigger, because this stored procedure that is originally used by an application's functionality, and it is performed to reconstruct a totals table by recalculating all lines of movement. Intends to make the recalculation of movements that contain only references to specific values ??entered in the first table, to expedite the process.
this totalling has to be on realtime, because this controls the number of items in a certain table and the only way to have the real values is by runing this SP when they are inserted by a specific document.