Jeff, you've come up with a nice, simple method for doing this. It made me go back and look at how I had coded it in my application. My code...

Sure.

The data used to populate this table came from several tables, and our...

Thanks, Paul; you made my day!

Phil: I also started looking for a replacement for openXml. One suggestion was to use nodes, but in our system we have a variety of...

The xml that is input to this is usually small: a couple of dozen lines. It takes 6 milliseconds to populate the @xmlEdgeTbl via the openxml.

When I try this with...

Is there a DB setting that we need to set in order to execute this code? I cannot get it to run even if I remove the CREATE PROCEDURE statement...

Please use the code at the top of this discussion page instead. That will fix the problem.

Thanks, Lynn! Here's a possible minor tweak that I think makes one less trip through the loop (unless the total number of rows we're deleting is an exact multiple of...

This is a very useful idea, but it seems that there is a bug in the code. If you run the "usage" example at the top of the code, you...