Nice question. Luckily have not fallen into "Quoted Null" trap 🙂

Thanks Steve. I was not aware of this. Got to learn something new today 🙂

L' Eomot Inversé (10/14/2012)

---

Fun question.

I wonder how many people will fail to notice that although you've got everything ready to create the index you haven't actually done so, so the...

Ah..Good question to begin with our Monday morning 🙂

demonfox (10/12/2012)

---

Lokesh Vij (10/11/2012)

---

Thanks Sreenivas for the question. Indeed we discussed the situation of "Divide by zero error" in your earlier QOTD discussion forum "While Loop - 1".

All in all...

Thanks Sreenivas for the question. Indeed we discussed the situation of "Divide by zero error" in your earlier QOTD discussion forum "While Loop - 1".

All in all ending this week...

mark 4643 (10/10/2012)

---

Hi All

I'm trying to optimize a monstrous query in a report that a vendor supplied. Part of the query has SELECT TOP(100 PERCENT) which makes no sense to...

This query would give the best performance from all the queries posted above 🙂

SELECT dtStartDate,

(SELECT Max(dtRunDate)

...

I was hoping this too....Not every one got it correct!

Correct answers: 75% (9)

Incorrect answers: 25%...

Very simple and easy question 🙂

Initially I thought this division is the key to answer this question; as "0.00001" is...

Here is the query:

;WITH tempavg

AS (SELECT id,

weight,

...

Ah....an easy one. Thanks Sreenivas 🙂

Gazareth (10/9/2012)

---

Only one table at the time can have IDENTITY_INSERT ON.

I don't...

I take my words back. You are correct... Identity_insert will work only for one table at a time 🙂