You changed the WHERE clause as well?

Missed that bit, sorry.

This is always a problem when converting between strings and dates, and is avoided by using ISO 8601 format date strings, putting the...

Try AND rather than OR in your HAVING clause?

There's an interesting take on the problem from the ICO (the Information Commissioner's Office in the UK), linking this to GDPR, and the responsibility to patch systems regularly.

Thanks Steve.  Can you please link to the MS KB for SQL Server?  https://support.microsoft.com/en-us/help/4073225/guidance-for-sql-server

It looks as though you meant to in this passage:

January 5, 2018 at 4:17 am

#1974636

Hmm.

What do you get from the following queries?

SELECT * FROM Enrollment WHERE Grade IN ('PK','KG','01','02')
SELECT Grade, COUNT(*) FROM Enrollment GROUP BY Grade

There's a Connect item to increase / remove the file size limit for sqlcmd - https://connect.microsoft.com/SQLServer/feedback/details/1844733/sqlcmd-exe-file-size-limit-is-2-gb

I've sent a message over to one of the Redgaters who looks after this sort of thing.

or maybe just use ROW_NUMBER() OVER (PARTITION BY CustomerID ORDER BY OrderDate)

It looks as though it should be ASC rather then DESC sorting?  I could, of course, be...

Was this database part of an availability group?  There's a thing about lazy recycling of transaction log VLFs that might be what's causing problems / concerns.  https://blogs.msdn.microsoft.com/sql_pfe_blog/2013/06/27/lazy-log-truncation-clearing-of-sql-transaction-log-vlf-status-deferred/

I've just reproduced the problem with SQLCMD...  😀 - that just returns "A"

Not got SSMS 17.4; got the problem when running with SSMS 17.3.

The full string...