I loved this question so much I wanna hug you... *ahem*

Thank you for this question. I knew the answer from the top of my head because I've read about it not so long ago. Excellent opportunity for this question to...

Thank you for the question.

I was almost choosing the error answer because of the 10/0.00001 but then I drank some coffee and thought about it for one more second. 😀

Sean Lange (9/27/2012)

---

I found this one a bit off. I assumed that the two lines setting IDENTITY_INSERT were typos because otherwise this entire batch would insert no rows. However if...

I still don't get it. What does he mean by "insert the value"? :ermm:

Easy one but much appreciated. 😀

Loved the question! :w00t:

I'm loving the last QoTDs so far.

No catch, no hidden bug or limitation.

Just normal behavior.

I agree with Hugo. APPLY is a gem that is not known by many and that...

😀

Loved the question BTW. No catch, just expected behavior.

Great to see than 79% got it right.

I remember this being discussed lately in a different topic.

I love questions that expose limitations/features of a given functionality.

It helps me choose the...

Thank you for such a back-to-basics question!

Or you could use a stored procedure that would receive the employer's id as a parameter and then have the code to check that and return data from the correct...

Nobody's going to help you now that you started spamming the forums.

That smells homework and you could at least have posted DDL and DML code and what you have so...

I wasn't aware it was a myth. :w00t:

I failed...

As others suggested the best way would be identifying the records you need to update because if you use the date as the filter you might end up updating more...