Forum Replies Created

Viewing post 1 (of 2 total)

  • RE: OPENXML help

    I found syntax that works

    SELECT *

    FROM OPENXML (@XmlDocumentHandle, '/tz_data/Location/Landmarks/City',2)

    WITH ( LocationID char(10) '../../LocationID',

    Country char(30) '../../Country',

    ...

Viewing post 1 (of 2 total)