Home Forums SQL Server 2005 T-SQL (SS2K5) Query that Returns Month to Date and YTD in Same Record RE: Query that Returns Month to Date and YTD in Same Record

  • February 4, 2008 at 4:09 pm

    #774939

    with the CASE nested in the SUM, I got this:

    Msg 130, Level 15, State 1, Line 5

    Cannot perform an aggregate function on an expression containing an aggregate or a subquery.