OpenXML - retrieve complete xml

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss Content Posted by Raj Vasant » OpenXML - retrieve complete xml

OpenXML - retrieve complete xml

Rate Topic

Display Mode

Topic Options

Author

Message

reachven

Posted Tuesday, October 23, 2007 1:03 PM

Forum Newbie

Group: General Forum Members
Last Login: Friday, October 26, 2007 10:13 AM
Points: 2, Visits: 5

Hi,

I am trying to use OpenXML command in sqlserver, and i have this xml which is a little different than most examples in OpenXML related info.

"
I tried to set the pointer at rcn/itm level as you see below.

SELECT *
FROM OPENXML (@idoc, '/GAR/ALS/AL/RCN/it',2)
WITH ( cd varchar(10) '@cd',
name varchar(20) '@name',
ID varchar(30) '../../../../@ID'

)

when i do this i am able to get the attribute values at rcn level and AL level, but i do not know how to point to ALN or LUD level

Many thanks in advance.

Post #414063

« Prev Topic | Next Topic »

Permissions