Column 'ORCT.CardCode' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause.

Question

User-797751191 posted

Hi

Declare @SalesPerson nvarchar(10),@BpName nvarchar(100),@DocDate Date,@Amount decimal(10,2)
DECLARE insert_cursor CURSOR FOR 
SELECT T2.[SlpName],T1.[CardName],T0.[DocDate],Sum(T0.[NoDocSum]),
(Select Sum([NoDocSum]) FROM ORCT where CardCode = (Select CardCode from OCRD where CardCode = T0.CardCode)
)
FROM ORCT T0  
INNER JOIN OCRD T1 ON T0.[CardCode]=T1.[CardCode]
INNER JOIN OSLP T2 ON T1.[SlpCode] = T2.[SlpCode] 
where docdate between @frDate and @toDate
group by T0.[DocDate],T2.[SlpName],T1.[CardName]
order by T2.[SlpName],T1.[CardName]

Thanks