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

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 varchar
set @storeid = (select Default_Value from System_Default where Default_Name = 'Main_Store_ID')

if (@storeid = '2')
begin
update [System_User] set Sales_Code = 'LER50' where System_User_ID = 489242 and Sales_Code is null
end
if (@storeid = '35')
begin
update [System_User] set Sales_Code = 'AYA50' where System_User_ID = 519188 and Sales_Code is null
update [System_User] set Sales_Code = 'LER50' where System_User_ID = 519192 and Sales_Code is null
end
if (@storeid = '129')
begin
update [System_User] set Sales_Code = 'ONW50' where System_User_ID = 459192 and Sales_Code is null
end
if (@storeid = '142')
begin
update [System_User] set Sales_Code = 'INE50' where System_User_ID = 519377 and Sales_Code is null
update [System_User] set Sales_Code = 'MIC50' where System_User_ID = 519380 and Sales_Code is null
end
if (@storeid = '150')
begin
update [System_User] set Sales_Code = 'SHU50' where System_User_ID = 479111 and Sales_Code is null
end
if (@storeid = '155')
begin
update [System_User] set Sales_Code = 'ADA50' where System_User_ID = 469146 and Sales_Code is null
end
if (@storeid = '158')
begin
update [System_User] set Sales_Code = 'JUR50' where System_User_ID = 479210 and Sales_Code is null
end
if (@storeid = '165')
begin
update [System_User] set Sales_Code = 'KEL50' where System_User_ID = 489322 and Sales_Code is null
end
if (@storeid = '174')
begin
update [System_User] set Sales_Code = 'CHA50' where System_User_ID = 827 and Sales_Code is null
end
if (@storeid = '182')
begin
update [System_User] set Sales_Code = 'THO50' where System_User_ID = 120926 and Sales_Code is null
update [System_User] set Sales_Code = 'TEB50' where System_User_ID = 120933 and Sales_Code is null
update [System_User] set Sales_Code = 'LUT50' where System_User_ID = 121390 and Sales_Code is null
end
if (@storeid = '183')
begin
update [System_User] set Sales_Code = 'AMA50' where System_User_ID = 722 and Sales_Code is null
update [System_User] set Sales_Code = 'LIZ50' where System_User_ID = 723 and Sales_Code is null
update [System_User] set Sales_Code = 'NOZ50' where System_User_ID = 724 and Sales_Code is null
update [System_User] set Sales_Code = 'TEB50' where System_User_ID = 730 and Sales_Code is null
end
if (@storeid = '276')
begin
update [System_User] set Sales_Code = 'MOL50' where System_User_ID = 30269 and Sales_Code is null
end

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

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