Home Forums Article Discussions Article Discussions by Author Discuss content posted by Hugo Kornelis BETWEEN a hard place and a rock RE: BETWEEN a hard place and a rock

  • June 12, 2013 at 11:53 am

    #1623455

    sknox (6/12/2013)

    There is a bug in your answer. You say:

    This means that the first query returns all rows from MyTable, the second only the rows with NumericColumn equal to NULL. The EXCEPT removes the second set from the first, leaving the rows with NumericColumn equal to NULL in the result set. Apparently, there are five rows with NumericColumn = NULL.

    That should read:

    This means that the first query returns all rows from MyTable, the second only the rows with NumericColumn not equal to NULL. The EXCEPT removes the second set from the first, leaving the rows with NumericColumn equal to NULL in the result set. Apparently, there are five rows with NumericColumn = NULL.

    Thanks for catching that missing "not", sknox! You are completely right.

    (And thanks for the great demo code too!)

    Hugo Kornelis, SQL Server/Data Platform MVP (2006-2016)
    Visit my SQL Server blog: https://sqlserverfast.com/blog/
    SQL Server Execution Plan Reference: https://sqlserverfast.com/epr/