Print 'Doing pre run Checks to ensure script not already run';
Select * from Script_History where Script_Name='CooStoresStockCodeFix';
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 (26,27,43,71,76,90,96,106,107,110,115,118,126,127,128,131,151,162,164,171,242,251,262))
begin

UPDATE promotion set period_start = '2024-11-29', period_end = '2024-12-01', lockdowndate = '2024-11-11' where promotion_id = 283;

update stock_item set Stock_Code = replace(Stock_Code,'-','') where source_contract like '%erply%';

update stock_item set Stock_Code = replace(Stock_Code,' ','') where source_contract like '%erply%';

update stock_item set Stock_Code = replace(Stock_Code,'[','') where source_contract like '%erply%';

update stock_item set Stock_Code = replace(Stock_Code,']','') where source_contract like '%erply%';

update stock_item set Stock_Code = replace(Stock_Code,'/','') where source_contract like '%erply%';

update stock_item set Stock_Code = replace(Stock_Code,'\','') where source_contract like '%erply%';

end

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