How to write Stored Procedure's results to an HTML report file? 1

[royc75]

Hello,

When writing a SELECT query in a Query Analyser it is possible to write the results to File. Is it also possible to do it inside a Stored Procedure's code? In case yes, Can I also control the format of the file, for example an HTML report?

 

[gmmastros]

Lookup sp_makewebtask in books on line. Here is an additional resource for you to look at:

http://www.transactsql.com/html/sp_makewebtask.html

-George

Strong and bitter words indicate a weak cause. - Fortune cookie wisdom

 

[royc75]

Thank you Gerorge, looks like it's what I am looking for.

 

[gmmastros]

I should have mentioned it before, but according to Books On Line for SQL 2005...

sp_makewebtask is retained for backward compatibility. New Web pages are more easily created using Microsoft SQL Server 2005 Reporting Services (SSRS).

To execute sp_makewebtask you must be a member of the sysadmin fixed server role.

This feature will be removed in the next version of Microsoft SQL Server. Do not use this feature in new development work, and modify applications that currently use this feature as soon as possible.

-George

Strong and bitter words indicate a weak cause. - Fortune cookie wisdom