Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!
select SUM(inall.price *inall.qty_invoiced),ROUND(SUM((Case when inall.qty_invoiced=0 then art.amount else ((inall.price *inall.qty_invoiced)/hdr.exch_rate) end)),2) as SalesTotal, hdr.slsman,MONTH(hdr.inv_date) as SalesMonth,hdr.co_num from inv_hdr hdr INNER JOIN inv_item_all inall ON hdr.inv_num=inall.inv_num LEFT OUTER JOIN artran art ON hdr.inv_num=art.inv_num Left outer join custaddr custadd ON hdr.cust_num= custadd.cust_num LEFT Outer Join coitem co ON custadd.cust_num=co.cust_num where YEAR(hdr.inv_date)= YEAR(getdate()) and (hdr.slsman ='F000001' and hdr.co_num='SFT0003575' ) and art.type in('I','C') and (MONTH(hdr.inv_date))=2 and (SUBSTRING( co.non_inv_acct,1,1)=5 or co.non_inv_acct is null) and custadd.cust_seq=0 group by (MONTH(hdr.inv_date)),hdr.slsman,hdr.co_num
select sum((qty_invoiced* price)/7.47) as Total from inv_item_all where co_num='SFT0003575' group by co_num
Join the community of 500,000 technology professionals and ask your questions.