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 3:26 am

    #1338233

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

    You do not know ISNULL ?

    ISNULL(SUM(SalesTestData.SaleQty),0)