How to send emails by any format using different SQL Select statements?

Asked Oct 10 '17 at 19:07

Active Oct 10 '17 at 19:07

Viewed 30 times

I have few SQL Scripts (4 select statements & each 2 from 2 different databases).

I need to add them and set all in single e-mail sending in .csv or HTML format. Is there any option in SSMS or do I have any options? I tried with UNION ALL and did lot google search but not much info helps me.

asked Oct 10 '17 at 19:07

CR241

2,293
1
12
30

Are the databases accessible via the same connection? – WillardSolutions Oct 10 '17 at 19:09
@EatPeanutButter Yes and both DB's in same instance. – CR241 Oct 10 '17 at 19:10
Did the `Union All` work? Have you tried `BCP` to create the `.csv` file? – SS_DBA Oct 10 '17 at 19:11
So which part exactly do you need help with? Retrieving the data from the database(s) or displaying it somewhere? – WillardSolutions Oct 10 '17 at 19:15
@EatPeanutButter for sending an email using SQL Scripts – CR241 Oct 10 '17 at 19:16
Possible duplicate of [How to send email from SQL Server?](https://stackoverflow.com/questions/13300881/how-to-send-email-from-sql-server) – WillardSolutions Oct 10 '17 at 19:19
@EatPeanutButter mostly not, I al ready checked that one. I need to add multiple selects from 2 different databases in to one email. – CR241 Oct 10 '17 at 19:22
So what is preventing you? There is nothing magical about queries pulling data from multiple databases. Just write your query that pulls addresses or whatever and the technique for sending them is absolutely no different at all. – Sean Lange Oct 10 '17 at 19:23

How to send emails by any format using different SQL Select statements?

0 Answers0