Thanks so much. Very tidy solution.

Hi Lowell,

This will solve a problem I am having.

Are you able to share your WebReader.zip again?

Thanks in advance.

Thanks for the detailed and METHODICAL analysis. I once was troubleshooting a performance problem in a large, complicated application and it came down to a "set quoted identifer on"...

Quick question regarding ignore_dup_key option:

If the attempted insert includes multiple "duplicates", how do you control which one succeeds.

From trial and error, it looks like if my set...

YES!!!!!

This does the trick. Thanks so much, I hope it addresses the original question as well.

I think I have a very similar need:

a) I have an "input" xml document that carries the input specifications for multiple tests:

declare @xmlInput xml

set @xmlInput = '<Tests>

<Test>

<Id>1</Id>

<Name>Test1</Name>

<Inputs>

<Input1>17</Input1>

...