Can XML- SQL Utility store XML data across tables?
Currently XML-SQL Utility (XSU) can only store to a single table. It maps a canonical representation of an XML document into any table/view. But of course there is a way to store XML with the XSU across table. One can do this using XSLT to transform any document into multiple documents and insert them separately. Another way is to define views over multiple tables (object views if needed) and then do the inserts… into the view. If the view is inherently non-updatable (because of complex joins,…), then one can use INSTEAD-OF triggers over the views to do the inserts.
