One more thing that I just realized about this issue. When you run it say from 5/1/2003 to present date, it creates a deadlock, but if you run it from...
We are actually not calling a stored proc., this is a query that is built in Access and runs against the server. Also, another thing that it is doing, it...