core-calc.sql

Exec sp_VolumeDriversbyPMG_Population 2, 'D' 
Exec sp_CheckoutSummary_15Min_w_BasketLine_Population 2, 'D' 
Exec sp_VolumeDriversbyPMG_Population 2, 'C' 
Exec sp_CheckoutSummary_15Min_w_BasketLine_Population 2, 'C' 


--delete from VolumeDriversbyPMG 
--Exec sp_Control_Run_Time '?', 'Adrian Test Full Run 1', 'Adrian A' 
Exec sp_Runcontrol 'R', 2, 6731 , '?' 
--Exec sp_Control_Run_Time 'U', 'Adrian A' 
--Exec sp_Control_Run_Time 'R' 

EXEC sp_BCS_Main_Input_Population 2, 'C', 'dbo', 'dbo' 

EXECUTE sp_WagePlanAdditionalSpend_Population

EXEC sp_Budget_Report_ActualvsPlannedvsBudgeted_Population @Store_Id = 6731, @Fiscal_Year = 2017

-- Delete muh stuff
UPDATE [prod].[WagePlan]
SET [State_Id] = '829C8724-E85F-49F3-B6B5-97386C44F241'
GO

DELETE FROM [prod].[WagePlanBcsTarget]
GO

DELETE FROM [prod].[DepartmentManagerRequest]
GO

DELETE FROM [prod].[BCS_Main_Input]
GO

-- Repopulate
Exec sp_VolumeDriversbyPMG_Population 2, 2, 'D'
Exec sp_CheckoutSummary_15Min_w_BasketLine_Population 2, 2, 'D'
Exec sp_VolumeDriversbyPMG_Population 2, 2, 'C'
Exec sp_CheckoutSummary_15Min_w_BasketLine_Population 2, 2, 'C'

Exec sp_Runcontrol 'R', 2, 6731 , '?'

EXEC sp_BCS_Main_Input_Population 2, 2, 'C', 'dbo', 'prod'

-- Generate charts
EXEC sp_Budget_Report_ActualvsPlannedvsBudgeted_Population @Store_Id = 6731, @Fiscal_Year = 2017