View Single Post
  #1 (permalink)  
Old June 4th, 2007, 06:48 PM
miamikk miamikk is offline
Authorized User
 
Join Date: Mar 2005
Location: , , .
Posts: 14
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via Yahoo to miamikk
Default Sql query output to XML or HTML file

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

Reply With Quote