Shredding XML with XQuery
Over on the Microsoft.Public.SqlServer.XML newsgroup, one Chris Kilmer asked a good question about how to shred a single XML document into multiple tables using multiple stored procedures. Chris's goal with this was to have each stored procedure update one table and pass the XML remaining nodes of the first document off to the next stored procedure. This is actually fairly easy except for one thing: maintaining referential activity between inserted elements.
Continues at: http://geekswithblogs.net/ktegels/archive/2006/01/20/ShredWithXQuery01.aspx
Sorry for the continues. If you'd rather not chance links, please subscribe to my new feed at: http://geekswithblogs.net/ktegels/Rss.aspx