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

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 Product_Catalogue_History(Product_Catalogue_ID, Product_Catalogue_Status_ID, reason, MonthEnd)
select pc.Product_Catalogue_ID, Last_Catalogue_Status_ID, 'Supplier Discontinued - Revert to previous status', GETDATE()
from Product_Catalogue pc
where product_catalogue_id in
(
select product_catalogue_id from product_catalogue where supplier_id = 1 and Product_Catalogue_Status_ID = 4 and product_id in (
select product_id from product where product_code in ('OS-1150'
))
);



update Product_Catalogue
set Product_Catalogue_Status_ID = Last_Catalogue_Status_ID,
Last_Catalogue_Status_ID = Product_Catalogue_Status_ID,
Last_Catalogue_Changed = GETDATE(),
Last_Change_Reason = 'Supplier Discontinued - Revert to previous status'
where product_catalogue_id in
(
select product_catalogue_id from product_catalogue where supplier_id = 1 and Product_Catalogue_Status_ID = 4 and product_id in (
select product_id from product where product_code in ('OS-1150'
))
);


IF (SELECT COUNT(0) FROM seasonalproduct WHERE hq_product_id = 36627) = 0
    BEGIN
        INSERT INTO seasonalproduct(hq_product_id, frommonth, tomonth) VALUES(36627,10,2)
    END

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

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