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


declare @StoreId int;

set @StoreId = (select default_value from system_default where Default_Name = 'Main_store_id');

If(@StoreId in (290,34,164,312,213,319,154,301))
begin

insert into Product_Catalogue_History(Product_Catalogue_ID, Product_Catalogue_Status_ID, reason, MonthEnd)
select pc.Product_Catalogue_ID, Product_Catalogue_Status_ID, 'Disc as per Ateeq', GETDATE()
from Product_Catalogue pc
where product_catalogue_id in
(
select product_catalogue_id from product_catalogue where supplier_id = 1  and product_id in (
select product_id from product where hq_product_id in (42811))
);



update Product_Catalogue
set Product_Catalogue_Status_ID = 3 ,
Last_Catalogue_Status_ID = Product_Catalogue_Status_ID,
Last_Catalogue_Changed = GETDATE(),
Last_Change_Reason = 'Disc as per Ateeq'
where product_catalogue_id in
(
select product_catalogue_id from product_catalogue where supplier_id = 1 and product_id in (
select product_id from product where hq_product_id in (42811))
);



end

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