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 d.OpCo ,d.SUVCVndrNum ,d.VndrNum ,ItemNum ,sum(Cases) [Case Volume] ,sum(FOB) [COGS ($)] ,sum(isnull(FrtPerCase, 0)*Cases) [Freight Cost ($)] ,sum(isnull(LEIPerCase, 0)*Cases) [LEI ($)] ,max(isnull(FrtPerCase, 0)) [Freight Cost / Case ($)] ,max(isnull(LEIPerCase, 0)) [LEI ($) / Case] from tbl_testingfreight d left outer join test.dbo.[OpCo Locations] o on d.OpCo = o.OpCo cross join (select distinct sourcinginitiative from [freightPO-OPCO]) si where SourcedCases > 0 group by d.OpCo ,d.SUVCVndrNum ,d.VndrNum ,ItemNum order by d.OpCo ,ItemNum
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
13 Experts available now in Live!