Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.
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
|Batch & SQLCMD & SQL: execute maintenance plan outside sql||13||51|
|Open A Form without Loading All the Records of Its Recordsource||6||43|
|I need help using SQL case statements in where clauses||3||23|
|Trigger C# code inside the SQL Server||6||25|