It's weird actually. There's no obvious reason why RANK() and ROW_NUMBER() should be faster than MIN(), but they clearly are when you look at the differences in the execution...

Heh. Fair enough, I never have to do it so I forget the exact language names sometimes.

None of these actually do what John asked Paresh.

Agreed Jeff. Sergiy's example succinctly proves my point.

Thanks, Sergiy!

Can you show us the execution plan.

Set Language 'english'

Duplicate post. Please reply here http://www.sqlservercentral.com/Forums/Topic637721-147-1.aspx

Heh. Good one. 🙂

A "query" probably has to be a single statement.

You cannot do expressions in the EXECUTE command. You need to do them in a preceding SET or SELECT.

RBarryYoung (1/15/2009)

---

Secondly, the WHERE clause must be evaluated before the output columns. That's required by the ANSI SQL standards and SQL Server has been implemented and documented to conform...

ScottPletcher (1/15/2009)

---

Again, this code does work:

select isdate(col1), *

from #t

where isdate(col1) = 0

or datepart(year, col1) = 2001 --sql treats yr "1" as "2001"

SQL will definitely short circuit when it knows...

You may be...

Erp! Sorry, I missed that this was SQL Server 2000...

ScottPletcher (1/15/2009)

---

I thought SQL Server did...