|
|
 next
|
  Subject: XPath query
Author: Minollo I.
Date: 31 Aug 2007 02:52 PM
|
Have you tried using DataDirect XQuery (http://www.xquery.com) to do that?
DataDirect XQuery is bundled in Stylus Studio, and you can experiment with it. The solution to your problem would look something similar to this, assuming "demo" is the table containing the result:
for $row in collection("pubs.dbo.xml_documents")/xml_documents
return
let $xmldoc := (# ddtek:evaluate-in-memory #) {$row/xmldoc}
return
for $key in $xmldoc/TRANSFORM/KEY
for $value in $key/VALUE
return
ddtek:sql-insert("demo", "key_old", string($key/@OLD), "key_new", string($key/@new), "transform1", string($key/@TRANSFORM1), "value_old", string($value/@OLD), "value_new", string($value/@new), "description", string($value/@DESCRIPTION))
|
|
|
|
top