can you try to have your settings use 4 digits for hte year part?? That sould solve it.

Why not simply creating a temp table, make an insert statement and using that instead??

You mean WaitingInLineForLeftoverScraps???

No way waitingInLineForLeftoverScraps, I like those new nicknames .

If you must know Farrell

rgR'us

This version IS FASTER. Not by a lot, but enough to consider it on a system at least as a best pratice. Instead of converting from datetime to...

There you go .

This is the post where my new nickname was first used.

Ok I misunderstood the problem.

Can you post the ddl and sample data (DML) with the expected results.

And you can lock the tempdb with select into... which could be even worse.

How the h*ll can I be a resident ubiquitous spook genious???

Something's not right in here .

Might I suggest this version as it is math based instead of converts?

If you have a big resultset to convert, you'll see a difference.

dateadd(d, 0, datediff(d, 0, getdate()))

I never said no other names were heard .

It just returns true/false. As soons as the engine finds a hit, the query stops with true. I can't tell you much more than that.

Nice... didn't think of that one .

No... that column doesn't really exist in that query, it has to be processed.