Sean Lange (3/31/2016)

---

I like the question and the order by concern has already been pointed out. The part of the explanation that really bothers me is this: "It is recommended...

I think there is a typo in Listing 1 - the subquery in the column list is counting the total orders which have a 'ModifiedDate' of 2007-02-19. Should this...

Great article. Wish I had seen something like this a few weeks ago - we spent nearly 2 days trying to get this working!

In my opinion a better solution...