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.
SELECT TOP (100) PERCENT SOPNUMBE AS ORDER_NMBR, DOCDATE AS ORDER_DATE, BACHNUMB AS BATCH_NAME, CUSTNMBR AS CUST_NMBR, CUSTNAME AS CUST_NAME FROM dbo.SOP10100 WHERE (SOPNUMBE NOT IN (SELECT SOPNUMBE FROM dbo.SSG_V_SOP_SavedOrders)) AND (SOPTYPE = 2) AND (NOT (BACHNUMB = '')) AND (DATEDIFF(Day, DOCDATE, GETDATE()) > 6) ORDER BY ORDER_DATE DESC
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
19 Experts available now in Live!