Is it because a comes before A and therefore [A-G] doesn't include a?

John

It's not at all clear what you're trying to achieve, but something like this may work:SELECT
    COUNT(CASE
            WHEN pr.Due != 0 THEN 1
        END) [halfpaid]
,    COUNT(CASE
            WHEN pr.delivered...

Yes, well done - I imagine that's what they were looking for.  And I even learned something myself - I didn't realise you could use NULL instead of...

You can edit the properties of the constraint to change it to an OR instead of an AND (at least you can in SSIS, and a Maintenance Plan is just...

Your Check Database Integrity Task is waiting for the History Cleanup Task and the Notify Operator Task to complete.  But NOT will only be invoked if BUDT fails, which is...

Yes, I understand what the requirement is.  You asked for help to answer the questions.  I'm not answering them for you - that would defeat the purpose of their existence.

Are you saying that the vendor's code uses the first query, but you want to persuade them to use something like the second query?

When you say the second...

(1) Use a ROW_NUMBER() clause to number the rows so that the row you wish to keep (or wish to delete) in each partition is numbered 1.  Then write your...

If you're right, that's another good reason to use scripts instead of the GUI.

John

Like I said before, difficult to say without knowing what your expected results look like.  But, from memory, the splitter function returns the element and the ordinal position, so all...