• Sorry for not giving enough information

    CREATE TABLE #TestBasedOnYear

    (

    OrderDate DATETIME,

    TotalDue MONEY

    )

    INSERT INTO #TestBasedOnYear(OrderDate,TotalDue)

    SELECT '2001-07-01 00:00:00.000','27231.5495'

    UNION ALL

    SELECT '2001-07-01 00:00:00.000','1716.1794'

    UNION ALL

    SELECT '2001-07-01 00:00:00.000','19005.2087'

    UNION ALL

    SELECT '2002-01-01 00:00:00.000','36096.7069'

    UNION ALL

    SELECT '2002-01-01 00:00:00.000','556.2026'

    UNION ALL

    SELECT '2003-01-01 00:00:00.000','47633.1875'

    UNION ALL

    SELECT '2003-01-01 00:00:00.000','46.0291'

    UNION ALL

    SELECT '2004-01-01 00:00:00.000','9128.8743'

    UNION ALL

    SELECT '2004-01-01 00:00:00.000','52154.9009'

    UNION ALL

    SELECT '2004-01-01 00:00:00.000','38.7783'

    UNION ALL

    SELECT '2004-01-01 00:00:00.000','4650.7326'

    Out Put Should look like

    TotalDueForTheCurrentYear OverAllTotalDue

    65973.2861 198258.3498