Send data via email

Last Post 23 Apr 2009 05:29 AM by JASBRYDEN. 1 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
JASBRYDEN
New Member
New Member

--
20 Apr 2009 10: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 05:29 AM
Thanks

Very helpful
You are not authorized to post a reply.

Acceptable Use Policy