XML XPLICIT ERROR - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2008 Forums

Transact-SQL (2008)

XML XPLICIT ERROR

Author

Topic

jimoomba
Yak Posting Veteran

90 Posts

Posted - 2011-09-28 : 05:20:30

Hi All,

I need the XML to look like this using XML EXPLICIT:

<QueryWaiting version="B000">
<Authentication id="57985540">FONFSNPX</Authentication>
</QueryWaiting>
<QueryWaiting version="B000">
<Authentication id="57985539">NQIGUTXD</Authentication>
</QueryWaiting>

please see the code below that iam using now and suggest me in the right way ...please help me :

SELECT 1 AS Tag,
NULL AS Parent,
'B000' AS 'QueryWaiting!1!version' ,
NULL AS 'Authentication!2!id' ,
NULL AS 'Authentication!2!'
Union
SELECT
2 as tag,
1 as parent,
NULL,
ControlStationID,
[Password]
FROM SW_ControlStations
FOR XML EXPLICIT ,ROOT('Root')

rams

yosiasz
Master Smack Fu Yak Hacker

1635 Posts

Posted - 2011-09-28 : 15:04:46

please provide sample data

If you don't have the passion to help people, you have no passion

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources