Thanks for your reply Fitz. That's what I got for posting without testing. That means that CTE for deletes have not much value. I can rewrite it to make it...

I will try to explain, even having no time to set up a test.

A delete can use indexes to find the deletion key, especially when it is a small...