Read this Gartner Research Note and discover how your IT organization can automate and optimize DevOps processes using a toolchain architecture.
select POSHEADER.transact, right(replicate('0',4) + convert(varchar,POSHEADER.snum),4), POSHEADER.statnum, whoclose, convert(varchar, timeend ,120), case when POSHEADER.finaltotal > 0 then 'Sale' else 'Return' end as Type, case when POSHEADER.status = 3 then 'Successful' else 'Failed' end as Status, METHODPAY.descript, (select sum(costeach*quan) from dba.posdetail where prodtype in (0,1) and opendate = 20130628 and posdetail.transact = posheader.transact group by posheader.transact) as ItemTotal , finaltotal, tax1, whoclose from dba.POSHEADER, dba.HOWPAID, dba.METHODPAY where POSHEADER.transact = HOWPAID.transact and HOWPAID.methodnum = METHODPAY.methodnum and HOWPAID.approved = 1 and POSHEADER.opendate = 20130628 and POSHEADER.transact not in (Select transact from dba.posheader where transact in (Select transact from dba.posdetail Group by transact having Count(*) = 1) and opendate = 20130628 ) order by POSHEADER.transact
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
23 Experts available now in Live!