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]
Member
140 Points
515 Posts
Column 'ORCT.CardCode' is invalid in the select list because it is not contained in either an agg...
Jul 21, 2020 06:15 AM|jsshivalik|LINK
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
Member
140 Points
515 Posts
Re: Column 'ORCT.CardCode' is invalid in the select list because it is not contained in either an...
Jul 21, 2020 07:00 AM|jsshivalik|LINK
Resolved