Sending result of several queries with Database Mail

• mick-979440

  Newbie

  Points: 3

  More actions

  January 5, 2009 at 1:42 am

  #128879

  This code works as expected and email the result of the query to the recipients:

  EXEC msdb.dbo.sp_send_dbmail

  @profile_name = 'ProfileName',

  @recipients = 'name@mail.com',

  @query = '

  SELECT * FROM table

  ' ,

  @subject = 'Query result';

  Is there any way I can include the result from several queries in one email? I would like to execute 5 queries and list the result from each of them, one by one, in the email.

• Jack Corbett

  SSC Guru

  Points: 184397

  More actions

  January 5, 2009 at 7:55 am

  #921141

  You can list several queries in the @Query parameter. I'd separate with either a GO or a ";", but white space works as well.

  Jack Corbett
  Consultant - Straight Path Solutions
  Check out these links on how to get faster and more accurate answers:
  Forum Etiquette: How to post data/code on a forum to get the best help
  Need an Answer? Actually, No ... You Need a Question