Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.
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
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
Join the community of 500,000 technology professionals and ask your questions.