Sql server Db Mail which can send mail for two or more queries

sql sql-server dbmail
Bhaskar Mishra picture Bhaskar Mishra · May 9, 2013 · Viewed 11k times · Source

I want to send db mail , which contains the result of two queries, how do I make it happen?

USE msdb
EXEC sp_send_dbmail
  @profile_name = 'try01',
  @recipients = '[email protected]',
  @subject = 'Table Values',
  @body = 'xxxxxxxxxxxxxx.',
  @execute_query_database = 'Reports',
  @query = 'SELECT * from Table'

Answer

Bhaskar Mishra picture Bhaskar Mishra · May 10, 2013

OK, This was easy as if you put a semicolon the result of both the queries are sent. Here it is:

USE msdb
EXEC sp_send_dbmail
  @profile_name = 'try01',
  @recipients = '[email protected]',
  @subject = 'Table Values',
  @body = 'xxxxxxxxxxxxxx.',
  @execute_query_database = 'Reports',
  @query = 'SELECT * from Table; select * from table2'

Only problem I have now is to get this into a decent looking format.

Related questions

Send email from SQL server for each row of a dataset

I have built a stored procedure for sending an email reminder to a set of employees each week. The SQL server agent runs a scheduled procedure each week that builds this weeks dataset of employees and then I need to …

Read More
How do I UPDATE from a SELECT in SQL Server?

In SQL Server, it is possible to insert rows into a table with an INSERT.. SELECT statement: INSERT INTO Table (col1, col2, col3) SELECT col1, col2, col3 FROM other_table WHERE sql = 'cool' Is it also possible to update a …

Read More
How do I perform an IF...THEN in an SQL SELECT?

How do I perform an IF...THEN in an SQL SELECT statement? For example: SELECT IF(Obsolete = 'N' OR InStock = 'Y' ? 1 : 0) AS Saleable, * FROM Product

Read More