I followed this sample to figure out how to send email from sql. http://msdn.microsoft.com/en-us/library/ms190307(v=sql.90).aspx I have it working, and a job runs it daily.
But I'd like to make it more dynamic. For example, when the sql query runs, if a certain condition isn't met, I don't need the email to send. (Lets say if the difference between two sql columns is > 500, then I don't need the email sent, however if the difference
between two collumns is < 500, then yes, I need the email to send. Is this even possible?
...
Go to the complete details ...