SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
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  

poorfisher
Starting Member

USA
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?

khtan
In (Som, Ni, Yak)

Singapore
17587 Posts

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


KH
Time is always against us

Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

India
52309 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
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs
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.12 seconds. Powered By: Snitz Forums 2000