View Single Post
  #2 (permalink)  
Old June 5th, 2007, 01:44 AM
happygv happygv is offline
Friend of Wrox
 
Join Date: Jun 2003
Location: Bangalore, KA, India.
Posts: 2,480
Thanks: 0
Thanked 1 Time in 1 Post
Default

KK,

Which version of SQL server are you using?

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

For HTML output, you may consider using sp_makewebtask and sp_runwebtask


_________________________
- Vijay G
Strive for Perfection
Reply With Quote