Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
tbraga
Starting Member
11 Posts |
 Posted - 2007-08-02 : 09:25:22
|
| This should be pretty easy. I have an email that currently goes out to the New Hires Team and gives them all the necessary information to set up all new hires. I am adding software[standard configurations] to the email as well. I would like to show the resultset from one of my queries that may have 10 rows(10 software applications). Because it has multiple rows, I cannot assign it to a varible. Is there any way to display the resultset within the message/body of the email????Any help would be great!Thanks in advance, Tim |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2007-08-02 : 11:00:33
|
| xp_sendmail has a @Query variable to which you pass your query whoe results you wish to attachset @attach_results = 'TRUE' if you want to attach query results as a file_______________________________________________Causing trouble since 1980blog: http://weblogs.sqlteam.com/mladenp |
 |
|
|
|
|
|
SQL Email Question,