Carlo Romagnano (10/3/2011)

---

tommyh (10/3/2011)

---

There are several problems with this question. One being that you cant declare @Start 2 times.

The other being that the answer is wrong. They both perform equally. I have executed the query as is (though with the @Start thing dealt with). With the 2 queries in the opposit order and one at a time. And the time is always roughly 100ms result (give or take 10ms).

I get the same execution plan (2005) for both queries. So im hoping that someone with more knowledge then me can enlighten us.

/T

You should execute the two batch separately, so, you can declare @Start twice.

But, I agree with you: the answere is wrong and hardly to establish which perform better.