This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.
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
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
|How do I find out to see if there is any open transaction in DB2 database ?||2||33|
|SqlServer amend PK column||5||16|
|SQL Server: Split string value in SELECT query only||5||30|
|SQL - Create table from a dynamic pivot||9||14|
Join the community of 500,000 technology professionals and ask your questions.