Post reply

Parsing XML Document

  • September 6, 2007 at 7:31 am

    #731814 

    EXEC sp_xml_preparedocument @hdoc OUTPUT, @x

    SELECT nodeData, nodeName
      FROM OPENXML(@hdoc, '//nodeData',1)
             WITH (
                   nodeData varchar(20) '.',
                   nodeName varchar(100) '@nodeName'
                   ) setNames
     WHERE nodeName >= 'record1'
       AND nodeName <= 'record999'

    This returns:

    nodeData nodeName

    -------------------- ----------------------------------------------------------------------------------------------------

    James record1

    John record2

    Bobby record3

    Regards,

    Andras

    Andras Belokosztolszki, MCPD, PhD
    GoldenGate Software

  • September 6, 2007 at 9:06 am

    #731882

    Thank you, thank you!!

Viewing 2 posts - 1 through 3 (of 3 total)

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