Thought I would update with what I found out.

Turns out Grant's suggestion was the key here

Grant Fritchey (10/20/2009)

You migh try changing the query to use a LEFT JOIN and eliminate...

I am having a very similar problem. I have an audit table that keeps track of inserts, deletes, and updates of all the tables in the database. It keeps track...