Send data via email

Last Post 23 Apr 2009 06:29 AM by JASBRYDEN. 1 Replies.
AddThis - Bookmarking and Sharing Button
Author Messages
JASBRYDEN
New Member
New Member

--
20 Apr 2009 11:20 AM
Hi

is it possible to use send mail task to send results of a query via email if it can be sent then what would the result look like will it be like excel type format or fixed length or comma delimited


and obviously -- how can I accomlish it


e.g.

Every day I would like the script below to run at 3pm

use data1
select * from dbo.BTStandardLoadDetail

I would like the data from this script be sent to an email to the persons I choose.

How to do this all in a script ?
JASBRYDEN
New Member
New Member

--
23 Apr 2009 06:29 AM
Thanks

Very helpful


Acceptable Use Policy
---