Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.
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.
Connect with top rated Experts
21 Experts available now in Live!