sql server programming: Creating xmldoc from SP -- sql server programming

Creating xmldoc from SP

Sanjay
6/22/2004 10:25:01 PM

sql server programming:

i want to create an xmldoc from SP..

I have used sp_makewebtask but what happens is -> due to the "Enter" or CRLF (which the sp does implicitly) the formatting goes haywire and thus the xml file is not generated properly as a result the parsing fails.And everything fails.
Is there any other way round or some thing that can solve this.

can anyone help
--

Re: Creating xmldoc from SP

Wayne Snyder
6/23/2004 8:00:56 AM

Take a look at Select ... for XML extensions to SQL Server

If you simply search for XML in books on line there will be many references
to assist you in returning an xml document from SQL..

--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)

I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org

[quoted text, click to view]
CRLF (which the sp does implicitly) the formatting goes haywire and thus the
xml file is not generated properly as a result the parsing fails.And
everything fails.
[quoted text, click to view]