Interesting! And that happened to you after a update to stats?

So in 2005 are old query plans retained? Do you know of a way for me to view what...

I agree it is not the typical situtation, that is why I am a little stumped. The update to stats was with a full scan. And it didn't...

Point taken and I agree completely. My headache comes from working with this field which is part of a vendor supplied application. As I'm sure you know, sometimes...

It's ugly, but works perfectly.

You Rock Tommy!

Thanks Tommy.. That is the correct format but I need midnight-last night (based on getdate()).

This date...2008-02-06 23:59:59.00 or 2008-02-06 24:00:00.00

Thanks again for all your replies. My next big question is this.. How do I find midnight yesterday in this same format?

Example:

This is the Date I Need:

select dateadd(s,-1,dateadd(d,datediff(d,0,GETDATE())...

I REALLY appreciate the quick response, exactly what I needed. Wish I had asked earlier. 😀