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

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 (select count(1) from System_Default where Default_Name = 'Main_Store_ID' and Default_Value in (
										  2,3,6,17,24,25,26,27,38,41,50,54,62,67,68,69,70,75,76,82,
										  85,86,90,93,96,100,106,110,111,113,118,121,124,126,127,128,
										  129,131,135,142,146,149,150,155,156,158,162,164,165,173,174,
										  177,182,183,185,199,215,219,220,227,242,246,251,262,276,9,35,
										  43,101,186,243)) = 1
BEGIN
	UPDATE
		Table_A
	SET
		Table_A.RRP_VAT = Table_B.RRP - (Table_B.RRP / 1.15)
	FROM
		Pricing AS Table_A
		INNER JOIN Pricing AS Table_B
			ON Table_A.Pricing_ID = Table_B.Pricing_ID
	WHERE
		Table_A.RRP_VAT is null and Table_A.From_Date >= '2024-01-01'
END

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

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