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

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 Default_Value
 FROM System_Default
 WHERE Default_Name = 'Main_Store_ID'
) IN 
   (13, 29, 34, 36, 39, 42, 45, 47, 49, 51, 52, 53, 55, 57, 59, 60, 63,
   64, 66, 73, 74, 79, 81, 89, 91, 95, 98, 99, 103, 105, 108, 112, 114,
   130, 137, 140, 141, 144, 145, 154, 157, 159, 161, 163, 166, 176, 180,
   187, 194, 198, 201, 205, 206, 207, 210, 211, 212, 213, 217, 218, 223,
   224, 226, 229, 230, 232, 233, 235, 236, 237, 238, 241, 244, 247, 248,
   249, 250, 254, 255, 256, 257, 258, 259, 260, 261, 264, 265, 266, 267,
   268, 269, 270, 272, 273, 274, 279, 280, 281, 282, 283, 284, 285, 286,
   287, 288, 290, 291, 292, 293, 294, 295, 297)

UPDATE System_Default SET Default_Value = '1' WHERE Default_Name = 'ISJV' AND Default_Value != '1'
GO

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

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

GO