Don't forget, for half the globe (if not half of your subscribers!), it's currently the middle of winter 🙂

This returns all but the...

Arrggghhh....

Got lost in my 1's and 0's and pressed the wrong option. Knew the right answer, just picked the wrong 'un.

Nice question Steve, thanks.

Wasn't sure between the large number of inserts & the index changes, so decided to do some research first, and then got it right.

Logic told me that...

Miles Neale (12/11/2014)

---

Never pass up an opportunity to learn, even if it is tricky or...

Thanks Tom.

Enlightening posts, as always.

TomThomson (12/10/2014)

---

Xavon (12/10/2014)

---

paul.knibbs (12/10/2014)

---

Emil Bialobrzeski (12/10/2014)

---

i saw lots of people on social sites having problems with:

most of the answers was 1. So saying Simple may apply differently to...

Well, I learnt something today. When Thanksgiving is 🙂

Seeing as the question needed two answers, and only two queries gave the same result, the answer was obvious. So no need...

SQLRNNR (11/3/2014)

---

ronmoses (11/3/2014)

---

Yes, I agree this seemed fairly obvious, but the fact that there are three correct answers (the first three options are all true) and I'm only permitted to...

Nice little question, and great explanation. Thanks.

Sergiy (4/30/2013)

---

antony-688446 (4/30/2013)

---

For those struggling with the difference between 'False' and 'Unknown', and how the IF statement works, consider what happens if we change the example code a little bit...

For those struggling with the difference between 'False' and 'Unknown', and how the IF statement works, consider what happens if we change the example code a little bit (I think...

But if you look here http://msdn.microsoft.com/en-us/library/ms173454(v=sql.100).aspx (aggregate functions in SQL 2008) GROUPING_ID is not listed.

But Here http://msdn.microsoft.com/en-us/library/ms173454(v=sql.105).aspx (SQL 2008R2) its is...

Did MS re-classify GROUPING_ID as an aggregate function between 2008...

Being pedantic, GROUPING_ID came in...

The biggest problem with using off-the-shelf software is you have no control over how it works, or fixing the bugs in it. The problem escalates as the software provider gets...