Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

OpenXML - retrieve complete xml Expand / Collapse
Author
Message
Posted Tuesday, October 23, 2007 1:03 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum 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 »

Add to briefcase

Permissions Expand / Collapse