I played around with the Datediff in the script just to test the script to get some results; I don't think this would apply here as we're telling it to...

I got a tip from my post on stackoverflow for this suggesting to use an extra column on my orderherader table and set a value there as a "flag" of...

So i was able to get this script working on my end after playing around with the different parameters;

IF Exists ( Select cht_number, cht_itemcode, cht_description from chargetype where last_updatedate>'11/11/2014')

execute msdb.dbo.sp_send_dbmail

@profile_name=Null,

@recipients='mail@domain.com',

@subject='Test',

@Execute_Query_Database='DB_Name',

@query='Select...