Print 'Doing pre run Checks to ensure script not already run';
            SELECT * FROM Script_History WHERE Script_Name='ProjectionUpdate20250519(1)';

            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 
            (1,281,197,198,1,232,255,214,31,98,132,19,32,23,286,271,99,290,285,51,305,134,103,211,105,137,278,193,159,248,52,282,226,264,109,257,34,73,18,235,112,294,252,7,192,245,8,78,77,95,114,11,116,239,244,300,228,283,297,241,201,268,66,206,119,233,80,53,169,91,120,65,270,202,236,13,293,292,247,223,284,72,14,87,289,224,302,203,249,260,122,217,277,55,166,39,179,40,296,303,298,258,92,307,21,261,273,42,44,269,291,108,130,15,56,191,12,136,20,213,48,280,133,181,81,36,161,309,57,176,180,167,139,140,218,141,250,74,143,267,45,308,144,145,46,79,58,256,184,190,59,88,60,259,295,16,4,230,61,221,207,306,47,238,274,63,275,210,254,212,272,153,154,163,29,5,28,64,22,194,266,49,225,299,229,279,301,288,234,188,157,237,89,10)) > 0
            UPDATE SystemSetting SET SettingValueDecimal = '9' WHERE SettingKey = 'ProjectionPeriod';

            IF (SELECT count(0) FROM System_Default WHERE Default_Name = 'Main_Store_ID' AND Default_Value IN
            (1,281,197,198,1,232,255,214,31,98,132,19,32,23,286,271,99,290,285,51,305,134,103,211,105,137,278,193,159,248,52,282,226,264,109,257,34,73,18,235,112,294,252,7,192,245,8,78,77,95,114,11,116,239,244,300,228,283,297,241,201,268,66,206,119,233,80,53,169,91,120,65,270,202,236,13,293,292,247,223,284,72,14,87,289,224,302,203,249,260,122,217,277,55,166,39,179,40,296,303,298,258,92,307,21,261,273,42,44,269,291,108,130,15,56,191,12,136,20,213,48,280,133,181,81,36,161,309,57,176,180,167,139,140,218,141,250,74,143,267,45,308,144,145,46,79,58,256,184,190,59,88,60,259,295,16,4,230,61,221,207,306,47,238,274,63,275,210,254,212,272,153,154,163,29,5,28,64,22,194,266,49,225,299,229,279,301,288,234,188,157,237,89,10)) > 0
            UPDATE SystemSetting SET SettingValueBit = 'True' WHERE SettingKey = 'ProjectionPeriodEnabled';

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

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