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.
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.