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
cdun2
SSCertifiable
Points: 7893
More actions
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.