Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails
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
|SQL Query Syntax Error||9||33|
|SQL Query to display duplicates ?||6||24|
|Updating ms sql with special characters||8||23|
|SQL Stored Procedure insert running but not inserting record||40||34|
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
15 Experts available now in Live!