• Maybe tomorrow QoTD will be:

    COUNT(*) AS MyCount

    And MyCount value will be 2 in this case (*) for the Null rows 😛

    Thanks & Best Regards,
    Hany Helmy
    SQL Server Database Consultant