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 |
|
pushp82
Yak Posting Veteran
83 Posts |
 Posted - 2012-09-19 : 01:55:18
|
| Hi Team,I need to fetch a report from database based on multiple query on daily bases and mail to team. I don't have BI so how can I accomplish this task with SSMS.I can use sp_send_dbmail to attach the file but which would be the easiest way to fetch records in excel and save to particular destination.Export wizard is really wearied in term of formate and I could not successes with multiple query report in one sheet.Please guide.ThanksPushp |
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
|
|
|
|
|
Automate mailing of Excel Report