FridayNightGiant (6/7/2016)

---

What sort of file do you want? A csv file or a tab delimited file? As you mention csv but the script you are posted is using tab as...

I was able to get this to work by using this sample query....but the output in excel file looks all messy....any idea, how to get the output as same as...

I was able to modify the script to do this but if someone is more than 1 yr but not yet 2 yrs, then I would like to display as...

Hi djj,

I am attaching the create script for the trigger.

Also, I found this old post....but no resolution it seems.

http://www.sqlservercentral.com/Forums/Topic269796-146-1.aspx

Anyone has any clue where to look at.

Users still getting duplicate emails.....not for every alert, but every now and then.

Thanks Lowell, I actually just found it now.

I'm not sure if this is the actual fix.

Anyway, I'll monitor and update.

Thanks again.

Okay, Thanks Lowell.

Sean,

If you don't mind, can you elaborate more on these steps.

Is the requirement that the email be sent real time?

Ans: No, I do not need it real time.

If not, maybe...

Yes, I tested your theory and this is what I get in my email body.

Following are the details:

ORDER_NUMBER : 116277.00

ID : 242078

Name : Mr. Tony Alexander

Meeting : [Missing Meeting]

TimeStamp...

Sean Lange (3/10/2016)

---

SQLisAwE5OmE (3/10/2016)

---

I am not trying to ignore you guys in terms fixing the code for multiple row inserts.....

But my trigger is not working as per my requirements, I...

I am not trying to ignore you guys in terms fixing the code for multiple row inserts.....

But my trigger is not working as per my requirements, I am trying to...

Sean Lange (3/9/2016)

---

SQLisAwE5OmE (3/9/2016)

---

Sean Lange (3/9/2016)

---

No. That means that your...

I have modified my trigger to do a join with another table to get the Meeting(Class) code since it doesn't appear on dbo.order table, the meeting code is inserted to...

Sean Lange (3/9/2016)

---

No. That means that your program inserts the...

When I purchased 2 programs(classes) in the same order, I got 2 separate emails. So, is that mean it's working?