Posted by M A Srinivas on 05/24/07 09:36

On May 24, 12:22 pm, "Marco Garutti" <marco.garu...@tecnoform.com>
wrote:
> Hi all,
> I've a query running under MS SQLServer2000 (Stored Procedures).
> I'd like to send it's result via e-mail, formatting the output in txt form
> or html form.
> Someone knows how to do it ? Have you got examples of code ?
> Thanks for the advice
>
> Marco Garutti

It may be better you can send through excel . Just run the SP in QA
and copy and paste to excel . Zip the excel file and send it to email

Note: Excel has limitation of 65,000 odd rows

If you want in text format , in QA , set output to text with delimiter
of your choice (,or |) and copy and paste to notepad .

[Back to original message]