Print 'Doing pre run Checks to ensure script not already run';
            SELECT * FROM Script_History WHERE Script_Name='ProjectionUpdate20250709_2';

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

            IF (SELECT count(0) FROM System_Default WHERE Default_Name = 'Main_Store_ID' AND Default_Value IN 
            (11)) > 0
            UPDATE SystemSetting SET SettingValueDecimal = '1' WHERE SettingKey = 'ProjectionPeriod';

            Print 'Insert into script history if everything else is cool';
	        INSERT INTO Script_History (RunDate,Script_Name) VALUES (CURRENT_TIMESTAMP,'ProjectionUpdate20250709_2');
            GO

	        IF @@ERROR != 0
		        BEGIN
			        RAISERROR ('UNABLE TO CONTINUE WITH SCRIPT', 11, 1);
			        RETURN;
		        END
            GO