SELECT YEAR(getdate())

YEAR(GETDATE());

SELECT TotalDueForTheCurrentYear = SUM(CASE WHEN YEAR(OrderDate) = YEAR(GETDATE()) THEN TotalDue ELSE 0 END),
    OverAllTotalDue = SUM(TotalDue)
FROM #TestBasedOnYear

SELECT TotalDueForTheCurrentYear = SUM(CASE WHEN OrderDate >= DATEADD( yyyy, DATEDIFF(yyyy,0,GETDATE()), 0) AND OrderDate < DATEADD( yyyy, DATEDIFF(yyyy,0,GETDATE()) + 1, 0) THEN TotalDue ELSE 0 END),
    OverAllTotalDue = SUM(TotalDue)
FROM #TestBasedOnYear

WITH Totals(Yr, TotalDueForTheCurrentYear, OverAllTotalDue) AS (
	SELECT 
		YEAR(OrderDate)
	,	SUM(TotalDue) OVER(PARTITION BY YEAR(OrderDate))
	,	SUM(TotalDue) OVER(PARTITION BY 1)
	FROM
		#TestBasedOnYear
	)
SELECT DISTINCT
	TotalDueForTheCurrentYear
,	OverAllTotalDue
FROM
	Totals
WHERE
	Yr = 2004