Can you tell me where I need to make the modification, to include multiple inserts.

Hi Sean\Martin,

Here is my revised code

USE [IMIS_TEST]

GO

/****** Object: Trigger [dbo].[Orders_Online_Reg] Script Date: 03/09/2016 09:29:20 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

ALTER TRIGGER [dbo].[Orders_Online_Reg]

ON [dbo].[Orders]

AFTER insert

AS

DECLARE @ORDER_NUMBER varchar(100)

DECLARE @ID...

Hi Sean & Martin,

Thanks for your feedbacks.

I am trying to test this trigger and see if I get an email when I register for a class in our test env...

Igor Micev (3/8/2016)

---

SQLisAwE5OmE (3/8/2016)

---

Igor Micev (3/8/2016)

---

Fist thing, did you check the fragmentation of indexes? Are the statistics of those tables updated?

If the issue still exists, then we're going to see...

Yes, indexes...

Sean Lange (3/7/2016)

---

SQLisAwE5OmE (3/7/2016)

---

Sean Lange (3/7/2016)

---

You created your trigger on Orders but you posted the ddl for logger_all. Does the Orders table have the same columns??? The bigger issue is...

Sean Lange (3/7/2016)

---

You created your trigger on Orders but you posted the ddl for logger_all. Does the Orders table have the same columns??? The bigger issue is that your trigger...

Hi Guys,

Please help.

I was trying to create the Insert Trigger, below is the code.

I did not write the code from scratch, found a DML trigger, from this post....

http://www.sqlservercentral.com/Forums/Topic1441032-1550-3.aspx

I...

Anyone heard of a tool called TaskCentre?

Hmm....don't really agree....I'm not touching...

Okay, thanks Sean.

I will try and see.

Sean Lange (3/1/2016)

---

SQLisAwE5OmE (3/1/2016)

---

This is my breakdown of requirement.

-Check if any changes to ACTIVITY table

-Activity_Type = 'MEETING'

-Product_Code = different product codes for different programs/classes.

-Find out the Product_Code for which had...

This is my breakdown of requirement.

-Check if any changes to ACTIVITY table

-Activity_Type = 'MEETING'

-Product_Code = different product codes for different programs/classes.

-Find out the Product_Code for which had activity

-First 2 characters...

Sean Lange (3/1/2016)

---

What version of sql server are you using? You have a lot of deprecated things going on in there. You have what appears to be a lack of...

drew.allen (2/24/2016)

---

SQLisAwE5OmE (2/24/2016)

---

Even though the other queries were working, I had to export to excel and remove duplicates, etc to get the unique 49 results.

This query gives me the exact...