Ahhh yes...  Absolutely right... Always a gotcha… 🙂

Great question...  I would have used the following sort instead for month number:

ORDER BY DATEPART(mm,oh.OrderDate)

Currently using SQL Server 2014 and have a solution (.ssmssln) with over 3000 scripts checked in to Team Foundation Server.  Downloaded 17.1 and could find no option for setting up Source...

Even more readable... WHERE js.next_run_date = CONVERT(VARCHAR(8), GETDATE(), 112)

The outer cast is unnecessary as datetime will equate with a valid date in string format (e.g., = '20151110')

Must be true... "they can't put anything on the internet that isn't true" (State Farm commercial) 🙂

Client -- "Yes, that's what we asked for, but that's not what we wanted"....

I took the "you" personally and since my version is SQL Server 2008 R2, the dev environment "I" use is BIDS. 🙂

Bill Mitchell

Production Support Analyst

EIS Web Development

EBSCO...

We certainly live in a liability crazy society. There's probably a fortune to be made in writing iron-clad, lawyer-proof disclaimers. A new cottage industry, perhaps... 🙂

It seems...