Godd qotd to start the week.

Nice article Greg.

Hey Steve - nice easy one to finish the week.

Cheers.

Well I was wrong, but at least I was in the majority.

'Lazy Spool' - never come across that before...

Nice QOTD Steve.

use AdventureWorks

SELECT SalesOrderID, ProductID, OrderQty,

ROW_NUMBER() OVER ( PARTITION BY SalesOrderID ORDER BY ProductID ) AS GNum, ...

Thanks for the QOTD Steve.

Easy (maybe too easy?).

Easy to some, not so easy to 41% of responders...

raulggonzalez (12/2/2013)

---

I guess this thread will grow really big.

I agree with some other peers, (and with BOL), there is just one possible answer for this question, which is include ORDER...

Not sure about this question - I answered but got it wrong...

Maybe we need better validation of QOTDs.

Thanks for the 7 points Steve.

Happy Thaknsgiving.

.. so the point of the question was...

The answer was so obvious I ignored it, thinking that was the reason for the post.

So there was no real need to post this other than to cause confusion?