Hi,
I have a db that has all of my xml documents, I would like to make a bunch of new dbs based on the document types which map to the document element name so for example if I do the query /LOV I get back 115491 Items, I would then like to put that into a db named LOV. How do I put the outputs of query on one db into another db, and does anyone have some code that would go through every /* and create a db by the name of the document element if that db does not exist and then place the document into that DB - or would that be insanely process intensive (there are 290422 items, 13 document types)?
Thanks, Bryan Rasmussen