OpenXML - retrieve complete xml

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

Viewing 0 posts

You must be logged in to reply to this topic. Login to reply