SQL SUM(Case) Error

Question

    SUM (CASE
                WHEN T6.Currency =
(
    SELECT A0.MainCurncy
    FROM '+@myTempTableName+'.dbo.OADM A0
)
                THEN T6.LineTotal
              else T6.TotalFrgn
            END) as [Mf.Amount],

I got this error:

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

Can anyone help me?

Possible duplicate of [SQL Server "cannot perform an aggregate function on an expression containing an aggregate or a subquery", but Sybase can](https://stackoverflow.com/questions/15751241/sql-server-cannot-perform-an-aggregate-function-on-an-expression-containing-an) — DrHouseofSQL, May 17 '18 at 11:34

score 0 · Answer 1 · answered May 17 '18 at 11:35

0

You need to fix the overall query:

SELECT . . .
    SUM(CASE WHEN A0.MainCurncy IS NOT NULL
             THEN T6.LineTotal
             ELSE T6.TotalFrgn
         END) as [Mf.Amount],

FROM . . . LEFT JOIN
     @myTempTableName+'.dbo.OADM A0
     ON A0.MainCurncy = T6.Currency

answered May 17 '18 at 11:35

Gordon Linoff

1,242,037
58
646
786

Now ı get this error :Column 'CHERRYFIELDGMBHCOKG.dbo.ORDR.U_URETIMULKESI' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause. – Yavuz Selim Kayış May 17 '18 at 11:41
Include the column in the `GROUP BY`. – Gordon Linoff May 17 '18 at 13:09

SQL SUM(Case) Error

1 Answers1