Quick and Easy way to email results - if any

• krypto69

  SSChampion

  Points: 13591

  More actions

  May 20, 2013 at 2:41 pm

  #273003

  Hi,

  I have this little query:

  Select deddedcode, dedlongDesc, deddatetimecreated from dedcode where deddatetimecreated > DATEADD(DAY, DATEDIFF(DAY, 0, GETDATE()), -1)

  I would like the results emailed to one person, but only if there are results (some days there won't be any new codes).

  What's the easiest way to accomplish this?

  It doesn't need to be a fancy report, plain text is fine.

• krypto69

  SSChampion

  Points: 13591

  More actions

  May 20, 2013 at 2:48 pm

  #1616791

  found a way...thanks anyway guys..

  IF (select count(*) from [e009]) > 0

  begin

  exec msdb.dbo.sp_send_dbmail

  @profile_name = 'Default',

  @recipients = 'me@example.com',

  @subject = 'warning',

  @query = 'select * from [e009]',

  @attach_query_result_as_file = 1,

  @query_attachment_filename = 'warning.csv'

  end

• durai nagarajan

  SSCoach

  Points: 15775

  More actions

  May 20, 2013 at 11:11 pm

  #1616838

  good , you found it on your own.

  Regards
  Durai Nagarajan