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',
namevarchar(20)'@name',
IDvarchar(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.