Of course you do, because it's not 2004 any more.

Here's a third alternative:

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

John