Totally agree with that. We run open query all the time and it is definitely not an issue.

Thank you. That will be very helpful.

I am wondering if anyone has used this in a CTE? I can't delete the duplicates from my actual tables but I would like to eliminate them within my...