2
Test by modifying your insert as
- insert into #temp
- select Invoice,
- sum(IsNull(T0.Qty,0)) as 'Quantity', T2.ItemName
- From DR1 T0
- inner join ORD T1 on T0.doc = T1.doc
- inner join Oit T2 on T0.Item = T2.Item
- where T1.DDATE = '2022/04/20'
- GROUP BY T1.Invoice,T2.ItemName
2
Hi Jignesh
Error - Isnull is not a recognized aggregate function.
Thanks