Insert trigger on master detail table

• raza.qadri

  Mr or Mrs. 500

  Points: 554

  More actions

  March 14, 2015 at 12:26 pm

  #315658

  I have two tables.

  Order table and order detail table.

  What I want to do is send notification to a service when an order is created. And I want to include both header and detail of the order.

  I can't get working with on insert trigger .

  Anyone can guide me how to go around with trigger ?

• roger.price-1150775

  Default port

  Points: 1458

  More actions

  March 15, 2015 at 2:46 am

  #1784087

  Create a separate table and add a row from within the trigger. Then create a job to scan that table, do whatever joins you need and send the email.