Can some one help me with the script to create a trigger that updates my payment table when a record is inserted in the Sales table.
Please take a look at the attached schema.
The royaltyAmount in the payments table is calculated based on the rate in the Royalty table(default 10%)
The contactID to make the payment to is taken from the royalty table. CreateTableScripts.sql