Nested SELECT ... FOR XML PATH Return ESCAPED <>s

Hi,
I'm trying to build a complicated web service request using the (much better than FOR XML EXPLICIT) PATH mode, and it's great and all except that when I nest them I am getting &lt, &gt for the nested nodes. Here's a snippit:

BEGIN

SET NOCOUNT ON;

SELECT
'P' AS "Item/DataBlkInd",
'A' AS "Item/PhoneQual/EditTypeInd",
'CITYCODE' AS "Item/PhoneQual/AddPhoneQual/City",
...
(SELECT DISTINCT
'R' AS "DataBlkInd",
'A' AS "EmailQual/EditTypeInd",
'1' AS "EmailQual/LineNum",
'T' AS "EmailQual/Type",
bpe.EmailAddress AS "EmailQual/EmailData"
FROM dbo.BPEmail bpe WHERE bpe.BusPartyId = @.CustomerId
FOR XML PATH('Item')) AS "node()",
...
FOR XML PATH('ItemAry'), ROOT('PNRBFSecondaryBldChgMods')
END

Any idea why the nested FOR XML PATH would be escaped, and how to return it as XML instead of "&lt Item &gt &lt ..."?

Many thanks!
Andy

Hi Andy

FOR XML queries per default return the resulting XML as a string value for backwards-compatibility reasons (regardless of the mode). So you should say

FOR XML PATH('Item'), TYPE

if you need the result to be XML. Also, I think you then will not need the AS "node()". Just leave the column alias away.

Best regards
Michael

Neewbie Question about SQL 2005 and MySql

Can both be run on the same service I have a asp.net application that need to use the MS sql 2005 and I have another application PHP that requires MySql. Can bot be run ont hte same server at the same time?

Yes, you can run both on the same machine at the same time. They act as separate services, and are completely unaware of eachother.

Need urgent help.. for SQL Server reporting services installation..

hi,

I have SQL Server Express edition installed on my PC , but now I need to use SQL Server reporting service, there is SP1 for express edition contains reporting service with express edition. Here..

http://msdn.microsoft.com/vstudio/express/sql/download/

Do I need to download 213 MB SQL Server 2005 Express Edition Toolkit SP1 ?

or there is any other method to use reporting services ?

Thanks

You will have to download the full install again, there is no way of installing the components seperatly. With SQl 2000 there used to be a seperate DL for Reporting Services, but in the 2005 stream they are all included in the one package.

Need Tutorial for SQL Server Reporting Tool

Hi

I need good tutorial for Sql Server Reporting Service .

I m a beginner ......

Regards

Niroshan

Free training CD ROMs

http://www.appdev.com/promo/freecd.asp?PC=SN00031

Videos

http://content.ricksql.com/content/

Google

http://www.google.ca/search?q=reporting+services+filetype%3Adoc+rendering&hl=en

http://www.google.ca/search?hl=en&q=reporting+services+filetype%3Adoc+handson&meta=

cheers,

Andrew

|||

Check out these:

TechNet Webcast: Introduction to Microsoft SQL Server 2005 Reporting Services (Level 200)

Monday, October 23, 2006

11:30 A.M.–12:30 P.M. Pacific Time

Tune in to learn about the many new and exciting features that have been added to Reporting Services since Microsoft SQL Server 2000.

and these links

SQL Server 2005 Webcasts: http://www.microsoft.com/events/series/msdnsqlserver2005.mspx or http://www.microsoft.com/events/series/technetsqlserver2005.mspx

SQL Server 2005 Virtual Labs: http://msdn.microsoft.com/virtuallabs/sql/