SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
Register Now and get your question answered!
Save Password
Forgot your Password?

 All Forums
 SQL Server 2005 Forums
 Transact-SQL (2005)
 Email from SQL
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Starting Member

1 Posts

Posted - 04/26/2013 :  14:21:56  Show Profile  Reply with Quote
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?

In (Som, Ni, Yak)

17684 Posts

Posted - 04/28/2013 :  02:35:14  Show Profile  Reply with Quote
use Database Mail

Time is always against us

Go to Top of Page

Very Important crosS Applying yaK Herder

52326 Posts

Posted - 04/29/2013 :  01:21:05  Show Profile  Reply with Quote
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 MVP
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.03 seconds. Powered By: Snitz Forums 2000