SQL Server 2008 (not r2)


I am trying to get the Attribute values "TestAccount1" and
"TestAccount2" from the below XML. I can't seem to get the xquery
correct in order to get at the value. In my real stuff there are 5,000
<Row> elements.

Help!

Declare @xmlRaw Xml =
'<?xml version="1.0" encoding="utf-8"?>
<Report xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xmlns:xsd="http://www.w3.org/2001/XMLSchema"
xmlns="http://testdom.intrnl.com/quest/dev/v5/SchemaA"
devteamblue="false">
<Possibles>
<Column name="AccountName" />
</Possibles>
<Table>
<Row>
<AccountName value="TestAccount1">unwanted</AccountName>
<AccountGroup value="People" />
</Row>
<Row>
<AccountName value="TestAccount2">wanted</AccountName>
<AccountGroup value="Places" />
</Row>
</Table>
</Report>'

-- returns null
Select xItem.value('(AccountName)[1]','varchar(256)' ) as fff from
@xmlRaw.nodes('/') as x(xItem)


-- Help!

Thanks.

SnapDive wrote:

WITH XMLNAMESPACES (DEFAULT
'http://testdom.intrnl.com/quest/dev/v5/SchemaA')
Select xItem.value('(AccountName/@value)[1]','varchar(256)' ) as fff
from @xmlRaw.nodes('/Report/Table/Row') as x(xItem)

might do what you want, assuming you want to read out the "value"
attribute of the "AccountName" child of each "Row" element.


--

Martin Honnen --- MVP Data Platform Development
http://msmvps.com/blogs/martin_honnen/