SQL Server – Email Results of Stored Procedure Conditionally
Within a Stored Procedure, you may want the results of a particular query emailed to you, but only if there is a result. In other words, I don’t want to be notified when the result set size is 0.