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

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

update store set CompanyName = 'Cash Crusaders Stores (Pty) Ltd', VATRegNo = '4270290184',
RegNo = '2020/027120/07'
where store_id 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);

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

GO