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 |
|
poorfisher
Starting Member
1 Post |
 Posted - 2013-04-26 : 14:21:56
|
| Hi All!I have been tasked with getting sales data out to our sales team on an automated basis. What I have in mind is to generate and email per user with a table in the body with their sales YTD, Target YTD and % Target by category. I would then like to attached a file that will be pregenerated in a shared location. My problem is the best way to go about this with the SQL server. I could probably write a console .net app to do it. But was hoping to skip that and just use SQL Server. Thoughts? |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2013-04-28 : 02:35:14
|
use Database Mail
KH[spoiler]Time is always against us[/spoiler] |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-04-29 : 01:21:05
|
| SSRS is also an option where you can set a simple tabular report with your figures and add a subscription to it specifying your receipient list------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
|
|
|
|
|
|
Email from SQL