Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.
One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.
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
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
|point in time restore in SQL server||26||45|
|Returning Message/Value Back to Access from a SQL Server trigger||3||35|
|SQL- GROUP BY||4||24|
|Running Total Using new MS SQL Function||21||50|