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

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 = (
                           select Default_Value
                           from System_Default
                           where Default_Name = 'Main_Store_Id'
                       )
IF (@storeId IN ( 29, 34, 36, 45, 47, 49, 51, 53, 57, 59, 60, 63, 64, 73, 74, 79, 81, 89, 91, 95, 98, 108, 112, 130,
                  137, 140, 141, 145, 154, 159, 161, 163, 166, 176, 187, 194, 198, 201, 206, 207, 210, 212, 213, 218,
                  223, 226, 233, 235, 238, 247, 254, 255, 257, 258, 259, 260, 261, 264, 265, 267, 269, 270, 272, 274,
                  279, 280, 281, 282, 283, 285, 286, 287, 288, 290, 291, 292, 293, 294, 295, 297
                )
   )
BEGIN
    UPDATE Store_Detail
    SET Trading_Entitiy_Name = 'Cash Crusaders Stores (Pty) Ltd',
        Vat_Number = '4270290184',
        Reg_Number = '2020/027120/07';
END
GO

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

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

GO