Print 'Doing pre run Checks to ensure script not already run';
Select * from Script_History where Script_Name='StoreDetailUpdate08012025';
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;

set @StoreId = (select default_value from system_default where Default_Name = 'Main_store_id');

If(@StoreId in (1,13,28,29,34,36,39,42,45,47,49,51,52,53,55,57,59,60,63,64,65,66,73,74,79,81,89,91,95,98,99,103,105,108,112,113,114,120,130,137,140,141,144,145,154,159,161,163,166,176,180,194,198,201,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,266,267,268,269,270,272,273,274,279,280,281,282,283,285,286,287,288,290,291,292,293,294,295,297,298,299,301,303,304,305,307,308,309,310,311,779))
begin
update store_detail set trading_entitiy_name='Cash Crusaders Acornhoek',Trading_as_name='Cash Crusaders Stores (Pty) Ltd',NCC_Ref_No='NCRCP18105' where @StoreId=281;
update store_detail set trading_entitiy_name='Cash Crusaders Alberton City',Trading_as_name='Cash Crusaders Stores (Pty) Ltd',NCC_Ref_No='NCRCP18105' where @StoreId=287;
update store_detail set trading_entitiy_name='Cash Crusaders Arcadia',Trading_as_name='Cash Crusaders Stores (Pty) Ltd',NCC_Ref_No='NCRCP18105' where @StoreId=198;
update store_detail set trading_entitiy_name='Cash Crusaders Atlantis',Trading_as_name='Cash Crusaders Stores (Pty) Ltd',NCC_Ref_No='NCRCP18105' where @StoreId=1;
update store_detail set trading_entitiy_name='Cash Crusaders Atteridgeville',Trading_as_name='CASH CRUSADERS ATTERIDGEVILLE (PTY) LTD',NCC_Ref_No='NCRCP11432' where @StoreId=232;
update store_detail set trading_entitiy_name='Cash Crusaders Ballitoville',Trading_as_name='Cash Crusaders Stores (Pty) Ltd',NCC_Ref_No='NCRCP18105' where @StoreId=255;
update store_detail set trading_entitiy_name='Cash Crusaders Bethlehem',Trading_as_name='Cash Crusaders Stores (Pty) Ltd',NCC_Ref_No='NCRCP18105' where @StoreId=98;
update store_detail set trading_entitiy_name='Cash Crusaders Boardwalk Inkwazi',Trading_as_name='Cash Crusaders Stores (Pty) Ltd',NCC_Ref_No='NCRCP18105' where @StoreId=286;
update store_detail set trading_entitiy_name='Cash Crusaders Boksburg',Trading_as_name='CASH CRUSADERS BOKSBURG (PTY) LTD',NCC_Ref_No='NCRCP10287' where @StoreId=99;
update store_detail set trading_entitiy_name='Cash Crusaders Bridge City',Trading_as_name='Cash Crusaders Stores (Pty) Ltd',NCC_Ref_No='NCRCP18105' where @StoreId=290;
update store_detail set trading_entitiy_name='Cash Crusaders BT Ngebs',Trading_as_name='Cash Crusaders Stores (Pty) Ltd',NCC_Ref_No='NCRCP18105' where @StoreId=285;
update store_detail set trading_entitiy_name='Cash Crusaders Burgersfort',Trading_as_name='CASH CRUSADERS BURGERSFORT (PTY) LTD',NCC_Ref_No='TBA' where @StoreId=51;
update store_detail set trading_entitiy_name='Cash Crusaders Burgersfort Mall',Trading_as_name='Cash Crusaders Stores (Pty) Ltd',NCC_Ref_No='NCRCP18105' where @StoreId=305;
update store_detail set trading_entitiy_name='Cash Crusaders Carletonville',Trading_as_name='CASH CRUSADERS CARLETONVILLE (PTY) LTD',NCC_Ref_No='NCRCP13565' where @StoreId=103;
update store_detail set trading_entitiy_name='Cash Crusaders Carnival Mall',Trading_as_name='CASH CRUSADERS MALL AT CARNIVAL (PTY) LTD',NCC_Ref_No='NCRCP10359' where @StoreId=211;
update store_detail set trading_entitiy_name='Cash Crusaders Centurion',Trading_as_name='CASH CRUSADERS CENTURION (PTY) LTD',NCC_Ref_No='NCRP16642' where @StoreId=105;
update store_detail set trading_entitiy_name='Cash Crusaders Commercial Road',Trading_as_name='Cash Crusaders Stores (Pty) Ltd',NCC_Ref_No='NCRCP18105' where @StoreId=137;
update store_detail set trading_entitiy_name='Cash Crusaders Darras Centre',Trading_as_name='Cash Crusaders Stores (Pty) Ltd',NCC_Ref_No='NCRCP18105' where @StoreId=159;
update store_detail set trading_entitiy_name='Cash Crusaders Dobsonville',Trading_as_name='CASH CRUSADERS DOBSONVILLE (PTY) LTD',NCC_Ref_No='NCRP16643' where @StoreId=248;
update store_detail set trading_entitiy_name='Cash Crusaders Doringkloof',Trading_as_name='CASH CRUSADERS DORINGKLOOF (PTY) LTD',NCC_Ref_No='NCRCP13217' where @StoreId=52;
update store_detail set trading_entitiy_name='Cash Crusaders Dwarsloop',Trading_as_name='Cash Crusaders Stores (Pty) Ltd',NCC_Ref_No='NCRCP18105' where @StoreId=282;
update store_detail set trading_entitiy_name='Cash Crusaders East Lynne',Trading_as_name='Cash Crusaders Stores (Pty) Ltd',NCC_Ref_No='NCRCP18105' where @StoreId=226;
update store_detail set trading_entitiy_name='Cash Crusaders East Rand Mall',Trading_as_name='Cash Crusaders Stores (Pty) Ltd',NCC_Ref_No='NCRCP18105' where @StoreId=264;
update store_detail set trading_entitiy_name='Cash Crusaders Elardus Park',Trading_as_name='Cash Crusaders Stores (Pty) Ltd',NCC_Ref_No='NCRCP18105' where @StoreId=257;
update store_detail set trading_entitiy_name='Cash Crusaders Empangeni',Trading_as_name='Cash Crusaders Stores (Pty) Ltd',NCC_Ref_No='NCRCP18105' where @StoreId=34;
update store_detail set trading_entitiy_name='Cash Crusaders Evaton',Trading_as_name='Cash Crusaders Stores (Pty) Ltd',NCC_Ref_No='NCRCP18105' where @StoreId=73;
update store_detail set trading_entitiy_name='Cash Crusaders Flamwood',Trading_as_name='Cash Crusaders Stores (Pty) Ltd',NCC_Ref_No='NCRCP18105' where @StoreId=235;
update store_detail set trading_entitiy_name='Cash Crusaders Florida',Trading_as_name='Cash Crusaders Stores (Pty) Ltd',NCC_Ref_No='NCRCP18105' where @StoreId=112;
update store_detail set trading_entitiy_name='Cash Crusaders Fochville',Trading_as_name='Cash Crusaders Carletonville (Pty) Ltd',NCC_Ref_No='NCRCP13565' where @StoreId=294;
update store_detail set trading_entitiy_name='Cash Crusaders Gezina',Trading_as_name='Cash Crusaders Stores (Pty) Ltd',NCC_Ref_No='NCRCP18105' where @StoreId=95;
update store_detail set trading_entitiy_name='Cash Crusaders Giyani',Trading_as_name='Cash Crusaders Stores (Pty) Ltd',NCC_Ref_No='NCRCP18105' where @StoreId=113;
update store_detail set trading_entitiy_name='Cash Crusaders Goodwood',Trading_as_name='Cash Crusaders Soneike (Pty) Ltd ta Cash Crusaders Goodwood Mall',NCC_Ref_No='NCRCP13924' where @StoreId=114;
update store_detail set trading_entitiy_name='Cash Crusaders Hatfield',Trading_as_name='CASH CRUSADERS HATFIELD (PTY) LTD',NCC_Ref_No='NCRCP12521' where @StoreId=244;
update store_detail set trading_entitiy_name='Cash Crusaders Hillcrest',Trading_as_name='Cash Crusaders Stores (Pty) Ltd',NCC_Ref_No='NCRCP18105' where @StoreId=283;
update store_detail set trading_entitiy_name='Cash Crusaders Jackal Creek',Trading_as_name='Cash Crusaders Stores (Pty) Ltd',NCC_Ref_No='NCRCP18105' where @StoreId=297;
update store_detail set trading_entitiy_name='Cash Crusaders Junction Mall',Trading_as_name='CASH CRUSADERS JUNCTION MALL (PTY) LTD',NCC_Ref_No='NCRCP12079' where @StoreId=241;
update store_detail set trading_entitiy_name='Cash Crusaders Kabega',Trading_as_name='Cash Crusaders Stores (Pty) Ltd',NCC_Ref_No='NCRCP18105' where @StoreId=201;
update store_detail set trading_entitiy_name='Cash Crusaders Katutura',Trading_as_name='Cash Crusaders Katutura',NCC_Ref_No='N/A' where @StoreId=268;
update store_detail set trading_entitiy_name='Cash Crusaders Kempstar Mall',Trading_as_name='CASH CRUSADERS KEMPSTAR (PTY) LTD',NCC_Ref_No='NCRCP14832' where @StoreId=66;
update store_detail set trading_entitiy_name='Cash Crusaders Kenako',Trading_as_name='Cash Crusaders Stores (Pty) Ltd',NCC_Ref_No='NCRCP18105' where @StoreId=206;
update store_detail set trading_entitiy_name='Cash Crusaders King Williams Town',Trading_as_name='Cash Crusaders Stores (Pty) Ltd',NCC_Ref_No='NCRCP18105' where @StoreId=233;
update store_detail set trading_entitiy_name='Cash Crusaders Knysna',Trading_as_name='Cash Crusaders Stores (Pty) Ltd',NCC_Ref_No='NCRCP18105' where @StoreId=53;
update store_detail set trading_entitiy_name='Cash Crusaders Kollonade',Trading_as_name='Cash Crusaders Stores (Pty) Ltd',NCC_Ref_No='NCRCP18105' where @StoreId=91;
update store_detail set trading_entitiy_name='Cash Crusaders Kraaifontein',Trading_as_name='Cash Crusaders Stores (Pty) Ltd',NCC_Ref_No='NCRCP18105' where @StoreId=120;
update store_detail set trading_entitiy_name='Cash Crusaders Krugersdorp',Trading_as_name='Cash Crusaders Stores (Pty) Ltd',NCC_Ref_No='NCRCP18105' where @StoreId=65;
update store_detail set trading_entitiy_name='Cash Crusaders Ladysmith',Trading_as_name='Cash Crusaders Stores (Pty) Ltd',NCC_Ref_No='NCRCP18105' where @StoreId=270;
update store_detail set trading_entitiy_name='Cash Crusaders Lambton Court',Trading_as_name='CASH CRUSADERS LAMBTON (PTY) LTD',NCC_Ref_No='NCRCP16686' where @StoreId=236;
update store_detail set trading_entitiy_name='Cash Crusaders Lansdowne',Trading_as_name='Cash Crusaders Rondebosch (Pty) Ltd ta Lansdowne',NCC_Ref_No='NCRCP12964' where @StoreId=13;
update store_detail set trading_entitiy_name='Cash Crusaders Lephalale Crossing',Trading_as_name='Cash Crusaders Stores (Pty) Ltd',NCC_Ref_No='NCRCP18105' where @StoreId=293;
update store_detail set trading_entitiy_name='Cash Crusaders Lifestyle @55',Trading_as_name='Cash Crusaders Stores (Pty) Ltd',NCC_Ref_No='NCRCP18105' where @StoreId=292;
update store_detail set trading_entitiy_name='Cash Crusaders Louis Trichardt',Trading_as_name='Cash Crusaders Stores (Pty) Ltd',NCC_Ref_No='NCRCP18105' where @StoreId=247;
update store_detail set trading_entitiy_name='Cash Crusaders Lydenburg',Trading_as_name='Cash Crusaders Stores (Pty) Ltd',NCC_Ref_No='NCRCP18105' where @StoreId=223;
update store_detail set trading_entitiy_name='Cash Crusaders Mall at 55',Trading_as_name='CASH CRUSADERS MALL AT 55 (PTY) LTD',NCC_Ref_No='NCRCP16928' where @StoreId=224;
update store_detail set trading_entitiy_name='Cash Crusaders Mams Mall',Trading_as_name='CASH CRUSADERS MAMS MALL (PTY) LTD',NCC_Ref_No='NCRCP12998' where @StoreId=249;
update store_detail set trading_entitiy_name='Cash Crusaders Maponya Mall',Trading_as_name='Cash Crusaders Stores (Pty) Ltd',NCC_Ref_No='NCRCP18105' where @StoreId=260;
update store_detail set trading_entitiy_name='Cash Crusaders Mayfield',Trading_as_name='CASH CRUSADERS MAYFIELD SQUARE (PTY) LTD',NCC_Ref_No='NCRCP12913' where @StoreId=217;
update store_detail set trading_entitiy_name='Cash Crusaders Melville',Trading_as_name='CASH CRUSADERS MELLVILLE (PTY) LTD',NCC_Ref_No='NCRCP10669' where @StoreId=55;
update store_detail set trading_entitiy_name='Cash Crusaders Meyerton',Trading_as_name='Cash Crusaders Stores (Pty) Ltd',NCC_Ref_No='NCRCP18105' where @StoreId=166;
update store_detail set trading_entitiy_name='Cash Crusaders Middestad',Trading_as_name='Cash Crusaders Soneike (Pty) Ltd',NCC_Ref_No='NCRCP13924' where @StoreId=39;
update store_detail set trading_entitiy_name='Cash Crusaders Mokopane',Trading_as_name='Cash Crusaders Stores (Pty) Ltd',NCC_Ref_No='NCRCP18105' where @StoreId=303;
update store_detail set trading_entitiy_name='Cash Crusaders Montclair Mall',Trading_as_name='Cash Crusaders Stores (Pty) Ltd',NCC_Ref_No='NCRCP18105' where @StoreId=298;
update store_detail set trading_entitiy_name='Cash Crusaders Moruleng',Trading_as_name='Cash Crusaders Stores (Pty) Ltd',NCC_Ref_No='NCRCP18105' where @StoreId=258;
update store_detail set trading_entitiy_name='Cash Crusaders MP Westgate',Trading_as_name='Cash Crusaders Stores (Pty) Ltd',NCC_Ref_No='NCRCP18105' where @StoreId=307;
update store_detail set trading_entitiy_name='Cash Crusaders Musina',Trading_as_name='Cash Crusaders Stores (Pty) Ltd',NCC_Ref_No='NCRCP18105' where @StoreId=261;
update store_detail set trading_entitiy_name='Cash Crusaders Nelspruit City',Trading_as_name='Cash Crusaders Nelspruit City',NCC_Ref_No='NCRCP15014' where @StoreId=273;
update store_detail set trading_entitiy_name='Cash Crusaders Newcastle',Trading_as_name='CASH CRUSADERS NEWCASTLE (PTY) LTD',NCC_Ref_No='NCRCP10588' where @StoreId=42;
update store_detail set trading_entitiy_name='Cash Crusaders North Cape Mall',Trading_as_name='Cash Crusaders Stores (Pty) Ltd',NCC_Ref_No='NCRCP18105' where @StoreId=269;
update store_detail set trading_entitiy_name='Cash Crusaders Northam',Trading_as_name='Cash Crusaders Stores (Pty) Ltd',NCC_Ref_No='NCRCP18105' where @StoreId=291;
update store_detail set trading_entitiy_name='Cash Crusaders Northcliff Piazza',Trading_as_name='Cash Crusaders Stores (Pty) Ltd',NCC_Ref_No='NCRCP18105' where @StoreId=108;
update store_detail set trading_entitiy_name='Cash Crusaders Northmead',Trading_as_name='Cash Crusaders Stores (Pty) Ltd',NCC_Ref_No='NCRCP18105' where @StoreId=130;
update store_detail set trading_entitiy_name='Cash Crusaders Phuthaditjhaba',Trading_as_name='Cash Crusaders Stores (Pty) Ltd',NCC_Ref_No='NCRCP18105' where @StoreId=213;
update store_detail set trading_entitiy_name='Cash Crusaders Piet Retief',Trading_as_name='Cash Crusaders Stores (Pty) Ltd',NCC_Ref_No='NCRCP18105' where @StoreId=280;
update store_detail set trading_entitiy_name='Cash Crusaders Potchefstroom',Trading_as_name='Cash Crusaders Stores (Pty) Ltd',NCC_Ref_No='NCRCP18105' where @StoreId=81;
update store_detail set trading_entitiy_name='Cash Crusaders President Square',Trading_as_name='Cash Crusaders Stores (Pty) Ltd',NCC_Ref_No='NCRCP18105' where @StoreId=36;
update store_detail set trading_entitiy_name='Cash Crusaders Pretoria North',Trading_as_name='Cash Crusaders Stores (Pty) Ltd',NCC_Ref_No='NCRCP18105' where @StoreId=161;
update store_detail set trading_entitiy_name='Cash Crusaders Pretorius Street',Trading_as_name='Cash Crusaders Stores (Pty) Ltd',NCC_Ref_No='NCRCP18105' where @StoreId=309;
update store_detail set trading_entitiy_name='Cash Crusaders Primrose',Trading_as_name='Cash Crusaders Stores (Pty) Ltd',NCC_Ref_No='NCRCP18105' where @StoreId=57;
update store_detail set trading_entitiy_name='Cash Crusaders Princess Crossing',Trading_as_name='Cash Crusaders Stores (Pty) Ltd',NCC_Ref_No='NCRCP18105' where @StoreId=176;
update store_detail set trading_entitiy_name='Cash Crusaders Princess Mkabayi Mall',Trading_as_name='Cash Crusaders Stores (Pty) Ltd',NCC_Ref_No='NCRCP18105' where @StoreId=310;
update store_detail set trading_entitiy_name='Cash Crusaders Quagga Shopping Centre - Pretoria West',Trading_as_name='CASH CRUSADERS QUAGGA (PTY) LTD',NCC_Ref_No='NCRCP16751' where @StoreId=180;
update store_detail set trading_entitiy_name='Cash Crusaders Randridge Mall',Trading_as_name='Cash Crusaders Stores (Pty) Ltd',NCC_Ref_No='NCRCP18105' where @StoreId=140;
update store_detail set trading_entitiy_name='Cash Crusaders Raslouw',Trading_as_name='Cash Crusaders Stores (Pty) Ltd',NCC_Ref_No='NCRCP18105' where @StoreId=218;
update store_detail set trading_entitiy_name='Cash Crusaders Richards Bay',Trading_as_name='Cash Crusaders Stores (Pty) Ltd',NCC_Ref_No='NCRCP18105' where @StoreId=141;
update store_detail set trading_entitiy_name='Cash Crusaders Rondebosch',Trading_as_name='Cash Crusaders Rondebosch',NCC_Ref_No='NCRCP12964' where @StoreId=250;
update store_detail set trading_entitiy_name='Cash Crusaders Roodepoort',Trading_as_name='Cash Crusaders Stores (Pty) Ltd',NCC_Ref_No='NCRCP18105' where @StoreId=74;
update store_detail set trading_entitiy_name='Cash Crusaders Sam Ntuli',Trading_as_name='Cash Crusaders Stores (Pty) Ltd',NCC_Ref_No='NCRCP18105' where @StoreId=267;
update store_detail set trading_entitiy_name='Cash Crusaders Sasolburg',Trading_as_name='Cash Crusaders Stores (Pty) Ltd',NCC_Ref_No='NCRCP18105' where @StoreId=45;
update store_detail set trading_entitiy_name='Cash Crusaders Savannah Mall',Trading_as_name='Cash Crusaders Stores (Pty) Ltd',NCC_Ref_No='NCRCP18105' where @StoreId=308;
update store_detail set trading_entitiy_name='Cash Crusaders Scottburgh',Trading_as_name='Cash Crusaders Richards Bay (Pty) Ltd',NCC_Ref_No='TBA' where @StoreId=311;
update store_detail set trading_entitiy_name='Cash Crusaders Sea Point',Trading_as_name='CASH CRUSADERS SEA POINT (PTY) LTD',NCC_Ref_No='NCRCP10369 ' where @StoreId=144;
update store_detail set trading_entitiy_name='Cash Crusaders Sebokeng',Trading_as_name='Cash Crusaders Stores (Pty) Ltd',NCC_Ref_No='NCRCP18105' where @StoreId=145;
update store_detail set trading_entitiy_name='Cash Crusaders Silverton',Trading_as_name='Cash Crusaders Stores (Pty) Ltd',NCC_Ref_No='NCRCP18105' where @StoreId=79;
update store_detail set trading_entitiy_name='Cash Crusaders Soneike',Trading_as_name='CASH CRUSADERS SONEIKE (PTY) LTD',NCC_Ref_No='NCRCP13924' where @StoreId=256;
update store_detail set trading_entitiy_name='Cash Crusaders Southdale',Trading_as_name='Cash Crusaders Stores (Pty) Ltd',NCC_Ref_No='NCRCP18105' where @StoreId=59;
update store_detail set trading_entitiy_name='Cash Crusaders Steeldale',Trading_as_name='Cash Crusaders Stores (Pty) Ltd',NCC_Ref_No='NCRCP18105' where @StoreId=60;
update store_detail set trading_entitiy_name='Cash Crusaders Steelpoort',Trading_as_name='Cash Crusaders Stores (Pty) Ltd',NCC_Ref_No='NCRCP18105' where @StoreId=259;
update store_detail set trading_entitiy_name='Cash Crusaders Stoneridge',Trading_as_name='Cash Crusaders Stores (Pty) Ltd',NCC_Ref_No='NCRCP18105' where @StoreId=295;
update store_detail set trading_entitiy_name='Cash Crusaders Table Bay Mall',Trading_as_name='CASH CRUSADERS TABLE BAY MALL (PTY) LTD',NCC_Ref_No='NCRCP10472' where @StoreId=230;
update store_detail set trading_entitiy_name='Cash Crusaders The Bridge',Trading_as_name='Cash Crusaders Stores (Pty) Ltd',NCC_Ref_No='NCRCP18105' where @StoreId=207;
update store_detail set trading_entitiy_name='Cash Crusaders The Glen',Trading_as_name='Cash Crusaders Stores (Pty) Ltd',NCC_Ref_No='NCRCP18105' where @StoreId=47;
update store_detail set trading_entitiy_name='Cash Crusaders The Mutual',Trading_as_name='Cash Crusaders Durbanville (Pty) Ltd',NCC_Ref_No='TBA' where @StoreId=304;
update store_detail set trading_entitiy_name='Cash Crusaders The Reef',Trading_as_name='Cash Crusaders Stores (Pty) Ltd',NCC_Ref_No='NCRCP18105' where @StoreId=238;
update store_detail set trading_entitiy_name='Cash Crusaders The Workshop',Trading_as_name='Cash Crusaders Stores (Pty) Ltd',NCC_Ref_No='NCRCP18105' where @StoreId=274;
update store_detail set trading_entitiy_name='Cash Crusaders Three Rivers',Trading_as_name='Cash Crusaders Stores (Pty) Ltd',NCC_Ref_No='NCRCP18105' where @StoreId=63;
update store_detail set trading_entitiy_name='Cash Crusaders Town Square',Trading_as_name='Cash Crusaders Stores (Pty) Ltd',NCC_Ref_No='NCRCP18105' where @StoreId=210;
update store_detail set trading_entitiy_name='Cash Crusaders Tramshed',Trading_as_name='Cash Crusaders Stores (Pty) Ltd',NCC_Ref_No='NCRCP18105' where @StoreId=254;
update store_detail set trading_entitiy_name='Cash Crusaders Tsakane Mall',Trading_as_name='Cash Crusaders Stores (Pty) Ltd',NCC_Ref_No='NCRCP18105' where @StoreId=212;
update store_detail set trading_entitiy_name='Cash Crusaders Tzaneen',Trading_as_name='Cash Crusaders Stores (Pty) Ltd',NCC_Ref_No='NCRCP18105' where @StoreId=272;
update store_detail set trading_entitiy_name='Cash Crusaders Umlazi',Trading_as_name='Cash Crusaders Stores (Pty) Ltd',NCC_Ref_No='NCRCP18105' where @StoreId=154;
update store_detail set trading_entitiy_name='Cash Crusaders Upington',Trading_as_name='Cash Crusaders Stores (Pty) Ltd',NCC_Ref_No='NCRCP18105' where @StoreId=163;
update store_detail set trading_entitiy_name='Cash Crusaders Vaal Mall',Trading_as_name='Cash Crusaders Stores (Pty) Ltd',NCC_Ref_No='NCRCP18105' where @StoreId=29;
update store_detail set trading_entitiy_name='Cash Crusaders Vanderbijlpark',Trading_as_name='Cash Crusaders Stores (Pty) Ltd',NCC_Ref_No='NCRCP18105' where @StoreId=28;
update store_detail set trading_entitiy_name='Cash Crusaders Vereeniging',Trading_as_name='Cash Crusaders Stores (Pty) Ltd',NCC_Ref_No='NCRCP18105' where @StoreId=64;
update store_detail set trading_entitiy_name='Cash Crusaders Vosloorus',Trading_as_name='Cash Crusaders Stores (Pty) Ltd',NCC_Ref_No='NCRCP18105' where @StoreId=194;
update store_detail set trading_entitiy_name='Cash Crusaders Vryburg',Trading_as_name='CASH CRUSADERS VRYBURG (PTY) LTD',NCC_Ref_No='NCRCP14747' where @StoreId=266;
update store_detail set trading_entitiy_name='Cash Crusaders Walmer',Trading_as_name='Cash Crusaders Stores (Pty) Ltd',NCC_Ref_No='NCRCP18105' where @StoreId=49;
update store_detail set trading_entitiy_name='Cash Crusaders Watercrest',Trading_as_name='Cash Crusaders Stores (Pty) Ltd',NCC_Ref_No='NCRCP18105' where @StoreId=299;
update store_detail set trading_entitiy_name='Cash Crusaders Watergate',Trading_as_name='CASH CRUSADERS WATERGATE (PTY) LTD',NCC_Ref_No='NCRCP10434' where @StoreId=229;
update store_detail set trading_entitiy_name='Cash Crusaders Welkom Checkers',Trading_as_name='Cash Crusaders Stores (Pty) Ltd',NCC_Ref_No='NCRCP18105' where @StoreId=279;
update store_detail set trading_entitiy_name='Cash Crusaders Westcliff (Chatsworth)',Trading_as_name='Cash Crusaders Stores (Pty) Ltd',NCC_Ref_No='NCRCP18105' where @StoreId=301;
update store_detail set trading_entitiy_name='Cash Crusaders Westgate Mall ',Trading_as_name='Cash Crusaders Stores (Pty) Ltd',NCC_Ref_No='NCRCP18105' where @StoreId=288;
update store_detail set trading_entitiy_name='Cash Crusaders Wonderpark',Trading_as_name='CASH CRUSADERS WONDER PARK (PTY) LTD',NCC_Ref_No='NCRCP11001' where @StoreId=237;
update store_detail set trading_entitiy_name='Cash Crusaders Worcester',Trading_as_name='Cash Crusaders Stores (Pty)Ltd',NCC_Ref_No='NCRCP18105' where @StoreId=89;

end

Print 'Insert into script history if everything else is cool';
	Insert into Script_History (RunDate,Script_Name) Values (CURRENT_TIMESTAMP,'StoreDetailUpdate08012025');
	IF @@ERROR != 0
		BEGIN
			RAISERROR ('UNABLE TO CONTINUE WITH SCRIPT', 11, 1);
			RETURN;
		END
GO