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

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

IF EXISTS (SELECT * FROM sys.objects WHERE [name] = N'StockTakeReport_TR' AND [type] = 'TR')
BEGIN
      DROP TRIGGER [dbo].[StockTakeReport_TR];
END

insert into seasonalproduct (HQ_Product_Id,FromMonth,ToMonth)
values (42749,10,2);

insert into seasonalproduct (HQ_Product_Id,FromMonth,ToMonth)
values (42751,10,2);

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

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