Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.
UPDATE A SET MISC = '3.00', ORMISC = '3.00', DOCAMNT = B.[ORDERTOTAL] --,ORDOCAMT = B.ORDERTOTAL FROM TORDER A INNER JOIN (SELECT CUSTNMBR, ORDNUMBER,SUM(SUBTOTAL + TRDISAMT + FRTAMNT + MISC + TAXAMNT) AS [ORDERTOTAL] FROM TORDER WHERE (CUSTNMBR LIKE 'ET-%' OR CUSTNMBR LIKE 'ETF-%') AND ORDTYPE = '3' AND INVODATE > (GETDATE() - 1) GROUP BY CUSTNMBR, ORDNUMBER ) B ON A.CUSTNMBR = B.CUSTNMBR and A.ORDNUMBER = B.ORDNUMBER WHERE (A.CUSTNMBR LIKE 'ET-%' OR A.CUSTNMBR LIKE 'ETF-%') AND A.ORDTYPE = '3' AND A.INVODATE > (GETDATE() - 1)
Join the community of 500,000 technology professionals and ask your questions.