Print 'Doing pre run Checks to ensure script not already run';
Select * from Script_History where Script_Name='ROBulk20241001v2';
if @@ROWCOUNT!=0
	BEGIN
		RAISERROR('THIS SCRIPT HAS ALREADY BEEN RUN ON THIS SERVER, CANNOT CONTINUE, PLEASE CONTACT DEV',11,1);
		RETURN;
	END
GO
update SystemSetting set SettingValueBit = 1 where SettingKey = 'IsBulkingSeason';

insert into DecBulkingPerc (StartDate,EndDate,Perc)
values ('2024-09-10','2024-10-15',0);

insert into DecBulkingPerc (StartDate,EndDate,Perc)
values ('2024-10-16','2024-10-31',30);

insert into DecBulkingPerc (StartDate,EndDate,Perc)
values ('2024-11-01','2024-11-15',60);

insert into DecBulkingPerc (StartDate,EndDate,Perc)
values ('2024-11-16','2024-11-30',90);

insert into DecBulkingPerc (StartDate,EndDate,Perc)
values ('2024-12-01','2024-12-15',100);

Print 'Insert into script history if everything else is cool';
	Insert into Script_History (RunDate,Script_Name) Values (CURRENT_TIMESTAMP,'ROBulk20241001v2');
	IF @@ERROR != 0
		BEGIN
			RAISERROR ('UNABLE TO CONTINUE WITH SCRIPT', 11, 1);
			RETURN;
		END
GO