Greetings all, this is my first post.I've searched through the archives and haven't found quite what I'm looking for, so here goes.

I have two XML schemas which I've created and added into the same xml schema collection.The two schemas are very similar apart from a few items, and share most of the other elements.For external validation reasons, there must be two different schemas, and thus I have created two different namespaces rather than importing the first schema into the second.

Both schemas have an element named "DOCTYPE" which I'd like to query into a single column for display purposes, as these two schemas represent two different xml documents.

To simplify the problem, I have ns1 and ns2 in schema collection sc1.The table created has 3 columns, msgId -varchar, InsertDate, and xmldoc - associated with sc1.Both documents are inserted into the table and are correctly validated.