Checking the difference between isnull and coalesce

IsnullCoalesceDiff.sql

DECLARE @Date date = DATEADD(DAY, -1, GETDATE());
SELECT  SpentDate,
        SUM(SpentAmount) AS Total
FROM    dbo.RunningTotals
WHERE   SpentDate >= ISNULL(@Date, GETDATE())
GROUP BY 
		GROUPING SETS(
		SpentDate, -- Per date,
		() -- To include the overall total as well.
);
GO

DECLARE @Date date = NULL;
SELECT  SpentDate,
        SUM(SpentAmount) AS Total
FROM    dbo.RunningTotals
WHERE   SpentDate >= ISNULL(@Date, GETDATE())
GROUP BY 
		GROUPING SETS(
		SpentDate, 
		()
);
GO

DECLARE @Date date = DATEADD(DAY, -1, GETDATE());
SELECT  SpentDate,
        SUM(SpentAmount) AS Total
FROM    dbo.RunningTotals
WHERE   SpentDate >= COALESCE(@Date, GETDATE())
GROUP BY 
		GROUPING SETS(
		SpentDate, 
		()
);
GO

DECLARE @Date date = NULL;
SELECT  SpentDate,
        SUM(SpentAmount) AS Total
FROM    dbo.RunningTotals
WHERE   SpentDate >= COALESCE(@Date, GETDATE())
GROUP BY 
		GROUPING SETS(
		SpentDate, 
		()
);
GO