Send sql server job alert only when a query has rows to return - Server Fault
I have a query that checks if we've made sales of a particular stock item select * from merchand_history where stock_code = 'zzz007' and create_timestamp >= getdate() order by create_timestamp desc I'd like to have a sql job that emails a user (I guess us...