HiI have 2 queries that give 2 different result and I dont know why, could someone please tell me why Query 2 give me a different result? Query 1, this give me Qty = 55SELECT SUM(NumberOfCards) AS Qty, CardFormatFROM dbo.tbl_CardsWHERE (DateAdded BETWEEN CONVERT(DATETIME, '2014-07-06 11:50:00', 102) AND CONVERT(DATETIME, '2014-07-06 12:05:00', 102)) AND (IsFetched = 1) AND (Duplicate = 0)GROUP BY CardFormatQuery 2, this give me Qty 56 (QtyPaidCards + QtyFreeCards) SELECT CardFormat, CONVERT(VarChar, DATEADD(dd,DATEDIFF(dd,0,DateAdded),0),102) AS Dag, ISNULL(SUM(CASE WHEN NULLIF(TransactionID, '0') IS NOT NULL THEN NumberOfCards END), 0)AS QtyPaidCards, ISNULL(SUM(CASE WHEN TransactionID IN ('0', '') THEN NumberOfCards END), 0) AS QtyFreeCards FROM tbl_Cards WHERE IsFetched = 1 AND Duplicate = 0 AND (DateAdded BETWEEN CONVERT(DATETIME, '2014-07-06 11:50:00', 102) AND CONVERT(DATETIME, '2014-07-06 12:05:00', 102)) AND CardFormat = 'A5' GROUP BY CardFormat, DATEADD(dd,DATEDIFF(dd,0,DateAdded),0) ORDER BY DATEADD(dd,DATEDIFF(dd,0,DateAdded),0), CardFormat