I am a newbie to SQL and I would like to know how can I save the SQL SP query output to an XML or directly to an HTML file ? I need to know how it can be done programatically as I need to generate about 5K-8K reports changing 3 input variables in the SP.

The Stored Procedure and output can be viewed in the image below
http://www.fiu.edu/~atmakurk/kk/results.jpg

The input variables that change are @District, @Month and @RepType.

I would appreciate if anyone can guide me or provide me with link to an article or example on how its done.

Thanks
KK

KK,

Which version of SQL server are you using?

If it is Sql server 2000...
For XML output, you need to consider using at the end of SELECT statement.

For HTML output, you may consider using sp_makewebtask and sp_runwebtask


_________________________
- Vijay G
Strive for Perfection

I am using SQL server 2005.

FOR XML AUTO generates an xml file but do you know or direct me to syntax on how to save the file to a folder ?

You may use BCP utility for storing that into a file under a folder.

_________________________
- Vijay G
Strive for Perfection