?
Solved

Database Mail - Multiple queries within sp_send_dbmail.

Posted on 2010-01-07
2
Medium Priority
?
2,781 Views
1 Endorsement
Last Modified: 2012-05-08
Hi guys,

I was wondering if anyone had any luck running multiple queries within sp_send_dbmail.

What I would like to do is either :
1. Attach more than 1 attachment, each being the result of different queries ,or
2. Attach these results in different sheets within my excel attachment that is being sent via sp_send_dbmail.

Thanks for you assistance.

Regards,

Vinay
1
Comment
Question by:CrispyC4
2 Comments
 
LVL 13

Accepted Solution

by:
Wizilling earned 500 total points
ID: 26203825
sp_send_dbmail accepts only 1 sql query parameter.
For more complex requierments, you can try using the SSIS packages to run mulitple queries and generate multiple files (1 file multiple sheets).. and then send them using the send mail task

0
 

Author Comment

by:CrispyC4
ID: 26208099
Thanks Wizilling
0

Featured Post

Take Control of Web Hosting For Your Clients

As a web developer or IT admin, successfully managing multiple client accounts can be challenging. In this webinar we will look at the tools provided by Media Temple and Plesk to make managing your clients’ hosting easier.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I've encountered valid database schemas that do not have a primary key.  For example, I use LogParser from Microsoft to push IIS logs into a SQL database table for processing and analysis.  However, occasionally due to user error or a scheduled task…
So every once in a while at work I am asked to export data from one table and insert it into another on a different server.  I hate doing this.  There's so many different tables and data types.  Some column data needs quoted and some doesn't.  What …
SQL Database Recovery Software repairs the MDF & NDF Files, corrupted due to hardware related issues or software related errors. Provides preview of recovered database objects and allows saving in either MSSQL, CSV, HTML or XLS format. Ensures recov…
Stellar Phoenix SQL Database Repair software easily fixes the suspect mode issue of SQL Server database. It is a simple process to bring the database from suspect mode to normal mode. Check out the video and fix the SQL database suspect mode problem.
Suggested Courses

601 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question