Sorry - sussed it.   I was using the following within my query:

and isnull(e.enddate,GETDATE()) >= GETDATE()

I'm guessing the value returned by getdate() sometimes changes between the two...