Send data via email

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

20 Apr 2009 10:20 AM

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


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 ?
New Member
New Member

23 Apr 2009 05:29 AM

Very helpful

Acceptable Use Policy