Home Forums Article Discussions Article Discussions by Author Discuss content posted by Patrick Cahill Returning 0's in a SUM (SQL Spackle) RE: Returning 0's in a SUM (SQL Spackle)

  • June 14, 2011 at 7:29 am

    #1338362

    Alexey Voronin (6/14/2011)

    What's this COALESCE(SUM(SalesTestData.SaleQty),0) ?

    You do not know ISNULL ?

    ISNULL(SUM(SalesTestData.SaleQty),0)

    They are interchangeable. Both are the same thing except COALESCE() allows for more than one evaluation.

    /* Anything is possible but is it worth it? */