title: SQL Trigger Ideas
body: <p>I need to design a trigger that fires once I add a new record to the table[Transaction Table].
  So here is the workflow:</p>
  <p>User enters Services(Service Table)and Expenses(Expenses Table) in the system. Once they click button &quot;process invoice&quot; a row is created in the Transaction table.</p>
  <p>Trigger should fire when the user Clicks the &quot;Process Invoice&quot;(which internally would be addition of row in the Transaction Table). Trigger should create a new entry (row) in the expense table that would be 2% of total of all entries in the services table.</p>
  <p>I am new to Trigger writing.All suggestions are welcome.</p>