The idea is to insert data into another database table while the data is been inserted into the current table. The Stored Procedure does the insert of the data into a new table while the simple trigger calls the Stored Procedure. It is a simple process but it does its job. I could also have done this all with a trigger but by creating a Stored Procedure you can call this procedure from anywhere (other triggers, functions, or stored procedures) longest you pass the two required parameters.
Download the full script here: <<CopyKEKWORD_FieldData_with_SP_and_Trigger>>
Here is a sample image of the Stored Procedure:
Stored Procedure Sample
Sample image of the trigger:
MSSQL Trigger Sample