|
Ranjit.ileni
Posting Yak Master
India
181 Posts |
 Posted - 02/09/2013 : 01:49:53
|
Hi Experts,
if I run one Query then I will get this result:
Assume,
select responsibleprovider ,emailaddress from table1
responsibleprovider emailaddress
aaaa, bbbbb aaaar@uphs.upenn.edu
ddddd, Pppp ddddp@uphs.upenn.edu
if I run another query I get this result:
Assume,
select Count ,responsibleprovider from tablereport
Count responsibleprovider
6 aaaa, bbbbb
8 ddddd, Pppp
I need to send this people email about the number of reports waiting for them (knowing their email address from the previous SQL):
For example, contact Email will get email: You have 1 report
aaaa, bbbbb will get email: You have 4 reports
I am new to Mail functionality in SQL Server ,
Could you please advice me , how to send an mail to repective preoviders with some text.
Thanks!
--Irk |
Edited by - Ranjit.ileni on 02/09/2013 01:51:13
|
|
Sending Email in SQL Server
