I just tested out your method with a larger set of data and there is no significant speed improvement. Any other ideas?

..

Why yes, they are related. These queries...

Here's a stripped down version:

DECLARE @tbl AS TABLE (DocumentType INT, DocumentXML XML);

DECLARE @XML XML;

SELECT @XML = '

<my:myFields xmlns:my="http://schemas.somedomain.com/infopath/2003/appname" xml:lang="en-us">

<my:SelectedProductID>100</my:SelectedProductID>

<my:PECode>4.2.A</my:PECode>

</my:myFields>'

INSERT INTO @tbl (DocumentType, DocumentXML)

VALUES (236, @XML);

WITH XMLNAMESPACES...

Thanks. That will probably work for around 50% of my clients. For the others that do not have multiple processors, do you have any other suggestions?