Print 'Doing pre run Checks to ensure script not already run';
Select * from Script_History where Script_Name='SeasonalAdditions08012024';

if @@ROWCOUNT!=0
	BEGIN
		RAISERROR('THIS SCRIPT HAS ALREADY BEEN RUN ON THIS SERVER, CANNOT CONTINUE, PLEASE CONTACT DEV',11,1);
		RETURN;
	END
GO

INSERT INTO SeasonalProduct 
(HQ_Product_Id, FromMonth, ToMonth) 
VALUES 
(23739, 10, 12),
(23647, 10, 12),
(23641, 10, 12),
(23733, 10, 12),
(7506, 10, 12),
(793, 10, 12),
(23667, 10, 12),
(12575, 10, 12),
(23673, 10, 12),
(12535, 10, 12),
(23747, 10, 12),
(23653, 10, 12),
(23759, 10, 12),
(23753, 10, 12),
(17759, 10, 12),
(22935, 10, 12),
(22929, 10, 12),
(23731, 10, 12),
(23725, 10, 12),
(23699, 10, 12),
(10174, 10, 12),
(23671, 10, 12),
(23665, 10, 12),
(23719, 10, 12),
(12573, 10, 12),
(3768, 10, 12),
(23751, 10, 12),
(23679, 10, 12),
(23745, 10, 12),
(23651, 10, 12),
(23659, 10, 12),
(22933, 10, 12),
(3700 , 10, 12),
(23737, 10, 12),
(23643, 10, 12),
(23743, 10, 12),
(12574, 10, 12),
(23703, 10, 12),
(22927, 10, 12),
(23697, 10, 12),
(23717, 10, 12),
(3749 , 10, 12),
(23723, 10, 12),
(23749, 10, 12),
(7507 , 10, 12),
(23757, 10, 12),
(23663, 10, 12),
(23657, 10, 12),
(23695, 10, 12),
(23741, 10, 12),
(22931, 10, 12),
(873  , 10, 12),
(23735, 10, 12),
(22925, 10, 12),
(23701, 10, 12),
(23715, 10, 12),
(23669, 10, 12),
(3701 , 10, 12),
(23721, 10, 12),
(23675, 10, 12),
(23661, 10, 12),
(23649, 10, 12),
(23655, 10, 12),
(23755, 10, 12)

Print 'Insert into script history if everything else is cool';

	Insert into Script_History (RunDate,Script_Name) Values (CURRENT_TIMESTAMP,'SeasonalAdditions08012024');
	IF @@ERROR != 0
		BEGIN
			RAISERROR ('UNABLE TO CONTINUE WITH SCRIPT', 11, 1);
			RETURN;
		END
GO