Why did i notice the "not a trigger" after writing this... >_< At least Lynn addresses the problem at hand above (in that the OP has ruled out all 3...

Thanks for the heads up Phil!

Honestly, don't send email from triggers, they cause far more problems then they "solve". If a trigger fails, for what ever reason, then the INSERT/UPDATE/DELETE will also fail (and therefore...

How did I not notice this before... I (foolishly) assumed you declared your variables as a date, you hadn't, they were a varchar. Use the appropriate datatype for your data....

I hadn't changed your definition of your variables. It might be that your login in interpreting the second date as 20182108, which doesn't exist. Try using:

Ok, I'm pretty sure that this gets the same result. If it doesn't have a look at what I've done and see if you can understand the method. The number...

This is going to be difficult without the SQL. First step, can you post that? 6 joins isn't really a lot, in my view; i use plenty of queries that...

For sanity, I've done a little formatting to the file, however, I've uploaded as a txt file. SSC would also destroy any whitespace I added due to it's "unique" pasting...

That looks like a huge catch-all query, so I'm really not surprised it's running poorly. You'll likely want to change this to dynamic SQL. Gail wrote a great article on...