L' Eomot Inversé (5/17/2013)

---

You are demonstrating a lack of historical knowledge here.

SQL became "SQL" because someone other than IBM owned the rights to the original name the IBM developers who...

Hugo Kornelis (5/15/2013)

---

(and if you go out in the street and ask people if -5 is between -1 and -10, I'm willing to bet that 99% of all people will...

Cliff Jones (5/14/2013)

---

Nice question. This falls into that category where if you inadvertently did this in a real piece of production code, you would probably stare at it for...

declare @test int

set @test=-2

select case when @test between -1 and -10 then 'Order does not matter'

else 'Order matters' end as Conclusion

It would seem to me that order shouldn't matter....

The downside to joins is that they can permit duplication if referential...

Hugo Kornelis (5/2/2013)

---

Rune Bivrin (5/2/2013)

---

Not necessarily true. If your development server is case sensitive you run the risk of having more than one object with the same name, only with...

Good to know before trying to use conditional declarations.

I was initially leaning toward the right answer for the right reason, then talked myself out of it, thinking that SQL Server would be able to handle it. :hehe:

Of course,...

I too got it right for the wrong reason, thinking the second insert was the one that succeeded.

I had been nervous about that keyword too. It is apparently the default, and...

To get count() to include null values, you can simply...

Sean Lange (4/15/2013)

---

An interesting question. The duplicate ID's was certainly a nasty distraction. I managed to notice the ID issue but wonder what this question was really trying to test/teach....

I get the same results both ways, even for days with no guests of one gender or no guests at all.

CREATE TABLE #Guests (checkin date, checkout date, FullName varchar(50), Gender...

I would ordinarily add an "Else 0" prior to the End in those case statements rather than the isnull function. Is there a performance difference, or just personal preference?

I am curious on the rule against temp tables. Is that in preference for work tables?