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

• • Reply
  jsshivalik

  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

• • Reply
  jsshivalik

  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