You're exactly correct witht the identity values not resetting. I've modified the nested loop using one of Dinakar Nethi's techniquies

Here is the final code that works if anyone is...

Thank you for this idea, however I'm not convinced that the identity column values are the problem based on these two thoughts:

1) I can't conceive of the following query returning...