Print 'Doing pre run Checks to ensure script not already run';
Select * from Script_History where Script_Name='ReorderrightsFAC';
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 (243,
2,
6,
199,
182,
106,
24,
111,
164,
35,
165,
156,
121,
38,
86,
129,
174,
186,
41,
227,
276,
135,
25,
246,
3,
183,
142,
9,
17,
82,
149,
62,
158
))
begin
update [System_User] set Reorder_Override_Authority = 1, Par_Override_Authority=1, Reorder_On_Order=1 
where @StoreId =243 and First_name='Jody' and surname='Short';

update [System_User] set Reorder_Override_Authority = 1, Par_Override_Authority=1, Reorder_On_Order=1 where @StoreId =243 and First_name='Jody' and surname='Short';
update [System_User] set Reorder_Override_Authority = 1, Par_Override_Authority=1, Reorder_On_Order=1 where @StoreId =243 and First_name='Johnathan' and surname='Van Zyl';
update [System_User] set Reorder_Override_Authority = 1, Par_Override_Authority=1, Reorder_On_Order=1 where @StoreId =243 and First_name='Rudolph' and surname='Van Zyl';
update [System_User] set Reorder_Override_Authority = 1, Par_Override_Authority=1, Reorder_On_Order=1 where @StoreId =2 and First_name='Kurt' and surname='Pater';
update [System_User] set Reorder_Override_Authority = 1, Par_Override_Authority=1, Reorder_On_Order=1 where @StoreId =2 and First_name='Johnathan' and surname='Van Zyl';
update [System_User] set Reorder_Override_Authority = 1, Par_Override_Authority=1, Reorder_On_Order=1 where @StoreId =2 and First_name='Rudolph' and surname='Van Zyl';
update [System_User] set Reorder_Override_Authority = 1, Par_Override_Authority=1, Reorder_On_Order=1 where @StoreId =6 and First_name='Kallie ' and surname='hefer';
update [System_User] set Reorder_Override_Authority = 1, Par_Override_Authority=1, Reorder_On_Order=1 where @StoreId =6 and First_name='Annetjie' and surname='Visser';
update [System_User] set Reorder_Override_Authority = 1, Par_Override_Authority=1, Reorder_On_Order=1 where @StoreId =6 and First_name='Cheslin' and surname='Burt';
update [System_User] set Reorder_Override_Authority = 1, Par_Override_Authority=1, Reorder_On_Order=1 where @StoreId =199 and First_name='Rohan' and surname='Du Preez';
update [System_User] set Reorder_Override_Authority = 1, Par_Override_Authority=1, Reorder_On_Order=1 where @StoreId =182 and First_name='Jody' and surname='Short';
update [System_User] set Reorder_Override_Authority = 1, Par_Override_Authority=1, Reorder_On_Order=1 where @StoreId =182 and First_name='Johnathan' and surname='Van Zyl';
update [System_User] set Reorder_Override_Authority = 1, Par_Override_Authority=1, Reorder_On_Order=1 where @StoreId =182 and First_name='Rudolph' and surname='Van Zyl';
update [System_User] set Reorder_Override_Authority = 1, Par_Override_Authority=1, Reorder_On_Order=1 where @StoreId =106 and First_name='Michelle' and surname='Karrim';
update [System_User] set Reorder_Override_Authority = 1, Par_Override_Authority=1, Reorder_On_Order=1 where @StoreId =24 and First_name='Simon' and surname='Blevins ';
update [System_User] set Reorder_Override_Authority = 1, Par_Override_Authority=1, Reorder_On_Order=1 where @StoreId =111 and First_name='Nic' and surname='Abraham';
update [System_User] set Reorder_Override_Authority = 1, Par_Override_Authority=1, Reorder_On_Order=1 where @StoreId =164 and First_name='Michelle' and surname='Karrim';
update [System_User] set Reorder_Override_Authority = 1, Par_Override_Authority=1, Reorder_On_Order=1 where @StoreId =35 and First_name='kurt' and surname='Pater';
update [System_User] set Reorder_Override_Authority = 1, Par_Override_Authority=1, Reorder_On_Order=1 where @StoreId =35 and First_name='Johnathan' and surname='Van Zyl';
update [System_User] set Reorder_Override_Authority = 1, Par_Override_Authority=1, Reorder_On_Order=1 where @StoreId =35 and First_name='Rudolph' and surname='Van Zyl';
update [System_User] set Reorder_Override_Authority = 1, Par_Override_Authority=1, Reorder_On_Order=1 where @StoreId =165 and First_name='Nic' and surname='Abraham';
update [System_User] set Reorder_Override_Authority = 1, Par_Override_Authority=1, Reorder_On_Order=1 where @StoreId =156 and First_name='Nic' and surname='Abraham';
update [System_User] set Reorder_Override_Authority = 1, Par_Override_Authority=1, Reorder_On_Order=1 where @StoreId =121 and First_name='Folkers' and surname='Oosthuizen';
update [System_User] set Reorder_Override_Authority = 1, Par_Override_Authority=1, Reorder_On_Order=1 where @StoreId =38 and First_name='Kallie ' and surname='hefer';
update [System_User] set Reorder_Override_Authority = 1, Par_Override_Authority=1, Reorder_On_Order=1 where @StoreId =38 and First_name='anna' and surname='Visser';
update [System_User] set Reorder_Override_Authority = 1, Par_Override_Authority=1, Reorder_On_Order=1 where @StoreId =38 and First_name='jeremy' and surname='cloete';
update [System_User] set Reorder_Override_Authority = 1, Par_Override_Authority=1, Reorder_On_Order=1 where @StoreId =86 and First_name='Dawie' and surname='Diederichs ';
update [System_User] set Reorder_Override_Authority = 1, Par_Override_Authority=1, Reorder_On_Order=1 where @StoreId =129 and First_name='Nic' and surname='Abraham';
update [System_User] set Reorder_Override_Authority = 1, Par_Override_Authority=1, Reorder_On_Order=1 where @StoreId =174 and First_name='Kurt' and surname='Pater';
update [System_User] set Reorder_Override_Authority = 1, Par_Override_Authority=1, Reorder_On_Order=1 where @StoreId =174 and First_name='Johnathan' and surname='Van Zyl';
update [System_User] set Reorder_Override_Authority = 1, Par_Override_Authority=1, Reorder_On_Order=1 where @StoreId =174 and First_name='Rudolph' and surname='Van Zyl';
update [System_User] set Reorder_Override_Authority = 1, Par_Override_Authority=1, Reorder_On_Order=1 where @StoreId =186 and First_name='Kallie ' and surname='hefer';
update [System_User] set Reorder_Override_Authority = 1, Par_Override_Authority=1, Reorder_On_Order=1 where @StoreId =186 and First_name='Annetjie' and surname='Visser';
update [System_User] set Reorder_Override_Authority = 1, Par_Override_Authority=1, Reorder_On_Order=1 where @StoreId =186 and First_name='Christene' and surname='Gumede';
update [System_User] set Reorder_Override_Authority = 1, Par_Override_Authority=1, Reorder_On_Order=1 where @StoreId =41 and First_name='Rohan' and surname='Du Preez';
update [System_User] set Reorder_Override_Authority = 1, Par_Override_Authority=1, Reorder_On_Order=1 where @StoreId =227 and First_name='jody' and surname='Short';
update [System_User] set Reorder_Override_Authority = 1, Par_Override_Authority=1, Reorder_On_Order=1 where @StoreId =227 and First_name='Johnathan' and surname='Van Zyl';
update [System_User] set Reorder_Override_Authority = 1, Par_Override_Authority=1, Reorder_On_Order=1 where @StoreId =227 and First_name='Rudolph' and surname='Van Zyl';
update [System_User] set Reorder_Override_Authority = 1, Par_Override_Authority=1, Reorder_On_Order=1 where @StoreId =276 and First_name='Kurt' and surname='Ruatenback ';
update [System_User] set Reorder_Override_Authority = 1, Par_Override_Authority=1, Reorder_On_Order=1 where @StoreId =135 and First_name='kurt' and surname='Ruatenback ';
update [System_User] set Reorder_Override_Authority = 1, Par_Override_Authority=1, Reorder_On_Order=1 where @StoreId =25 and First_name='kurt' and surname='Ruatenback ';
update [System_User] set Reorder_Override_Authority = 1, Par_Override_Authority=1, Reorder_On_Order=1 where @StoreId =246 and First_name='kurt' and surname='Ruatenback ';
update [System_User] set Reorder_Override_Authority = 1, Par_Override_Authority=1, Reorder_On_Order=1 where @StoreId =3 and First_name='Nic' and surname='Abraham';
update [System_User] set Reorder_Override_Authority = 1, Par_Override_Authority=1, Reorder_On_Order=1 where @StoreId =183 and First_name='Kurt' and surname='Pater';
update [System_User] set Reorder_Override_Authority = 1, Par_Override_Authority=1, Reorder_On_Order=1 where @StoreId =183 and First_name='Johnathan' and surname='Van Zyl';
update [System_User] set Reorder_Override_Authority = 1, Par_Override_Authority=1, Reorder_On_Order=1 where @StoreId =183 and First_name='Rudolph' and surname='Van Zyl';
update [System_User] set Reorder_Override_Authority = 1, Par_Override_Authority=1, Reorder_On_Order=1 where @StoreId =142 and First_name='Louis' and surname='Valere';
update [System_User] set Reorder_Override_Authority = 1, Par_Override_Authority=1, Reorder_On_Order=1 where @StoreId =9 and First_name='Jody' and surname='Short';
update [System_User] set Reorder_Override_Authority = 1, Par_Override_Authority=1, Reorder_On_Order=1 where @StoreId =9 and First_name='Johnathan' and surname='Van Zyl';
update [System_User] set Reorder_Override_Authority = 1, Par_Override_Authority=1, Reorder_On_Order=1 where @StoreId =9 and First_name='Rudolph' and surname='Van Zyl';
update [System_User] set Reorder_Override_Authority = 1, Par_Override_Authority=1, Reorder_On_Order=1 where @StoreId =17 and First_name='Nic' and surname='Abraham';
update [System_User] set Reorder_Override_Authority = 1, Par_Override_Authority=1, Reorder_On_Order=1 where @StoreId =82 and First_name='Kurt' and surname='Pater';
update [System_User] set Reorder_Override_Authority = 1, Par_Override_Authority=1, Reorder_On_Order=1 where @StoreId =82 and First_name='Johnathan' and surname='Van Zyl';
update [System_User] set Reorder_Override_Authority = 1, Par_Override_Authority=1, Reorder_On_Order=1 where @StoreId =82 and First_name='Rudolph' and surname='Van Zyl';
update [System_User] set Reorder_Override_Authority = 1, Par_Override_Authority=1, Reorder_On_Order=1 where @StoreId =149 and First_name='Simon' and surname='Blevins ';
update [System_User] set Reorder_Override_Authority = 1, Par_Override_Authority=1, Reorder_On_Order=1 where @StoreId =62 and First_name='Lawrence' and surname='Nemakonde';
update [System_User] set Reorder_Override_Authority = 1, Par_Override_Authority=1, Reorder_On_Order=1 where @StoreId =62 and First_name='Ndiimafhi' and surname='Nemakonde';
update [System_User] set Reorder_Override_Authority = 1, Par_Override_Authority=1, Reorder_On_Order=1 where @StoreId =158 and First_name='Nic' and surname='Abraham';

end

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