Viewing post 1 (of 2 total)
I found syntax that works
SELECT *
FROM OPENXML (@XmlDocumentHandle, '/tz_data/Location/Landmarks/City',2)
WITH ( LocationID char(10) '../../LocationID',
Country char(30) '../../Country',
...
September 19, 2008 at 5:29 pm
#874508