I agree, thank you very much for your time on this matter. I am going to revise the query instead.

I have thought about a table valued function or trigger or something like that which will automatically update the date to end of day. The inserts will be done...

I suppose there are probably better ways to modify the query. Basically, the WHERE clause of the query is:

WHERE (GETDATE() - 1 <= EndDate)

If EndDate has a time of...

The issue was that a copy of the program that was being executed was somehow locked into cache on the server. After the program was unlocked it picked up...