Declare @fn Varchar(200) = 'Recardo'	
Declare @sn Varchar(200) = 'Rhode'
Declare @Un Varchar(200) = 'RecRhoOps'
Declare @pw Varchar(200) = 'RecRh9343'
Declare @Em Varchar(200) = 'recardor@cashcrusaders.co.za'
Declare @salescode Varchar(200) = 'RhoNO7473'
Declare @gu bigint = '257'

Select * from [System_User] Where First_Name=@fn and Surname = @sn AND Global_User_ID=@gu;
if @@ROWCOUNT =0
BEGIN
INSERT [dbo].[System_User]([Salutation_ID],[First_Name], [Middle_Name], [Surname], [ID_Number], [Identity_Type_ID], [Date_Of_Birth], [Preferred_Name], 
[Gender_Code], [Home_Address_1], [Home_Address_2], [Suburb], [Postal_Code], [City_ID], [Contact_No], [Cell_Number], [Email_Address], [Marital_Status_ID], 
[Ethnicity_ID], [Start_Date], [Termination_Date], [Leave_Entitlement], [Leave_Carried], [GP_Percentage], [Login_Name], [Password], [Supervisor_ID], [Sales_Code], 
[Last_Password_Reset], [Postal_Address_1], [Postal_address_2], [Postal_Suburb], [Postal_Post_Code], [Postal_City_ID], [Store_ID], [Locked], [Certification_Completed], 
[Global_User_ID]) 
VALUES 
(1,@fn, N'Ops', @sn, 'AA', 2,'2012-10-12' , @fn, 1, 'AA','AAA','AAA','7441', 2, '022','111', @Em, 4, 2,  '2012-10-12', '2012-10-12',CAST(1.74 AS Decimal(4, 2)), 
CAST(0.00 AS Decimal(4, 2)), CAST(0.00 AS Decimal(2, 2)), @Un, @pw, 2, @salescode,  CAST(0x0000E70D00A726AE AS DateTime), N'aaaaa', NULL, N'aaaa', N'7441', 2, 1, 0, 0, @gu); 
END

Select * from [System_User_Profile] Where system_user_id in (select system_user_id from [system_user] where first_name=@fn and Surname=@sn AND Global_User_ID=@gu);
if @@ROWCOUNT =0
BEGIN
INSERT INTO [System_User_Profile] ([Profile_ID],[System_User_ID],[Store_ID])
VALUES(1,(Select top(1) [System_User_ID] from [System_User] Where first_name=@fn and Surname=@sn AND [Global_User_ID]=@gu),1) 
END

Select * from System_User_Function Where system_user_id in (select system_user_id from [system_user] where first_name=@fn and Surname=@sn AND Global_User_ID=@gu and System_Function_ID = 3);
if @@ROWCOUNT =0
BEGIN Insert into System_User_Function (System_User_ID,System_Function_ID, Right_Type_ID, Store_ID) 
VALUES ((Select top(1) System_User_ID from [System_User] Where first_name=@fn and Surname=@sn AND Global_User_ID=@gu),3,1,1) 
END

Select * from System_User_Function Where system_user_id in (select system_user_id from [system_user] where first_name=@fn and Surname=@sn AND Global_User_ID=@gu and System_Function_ID = 4);
if @@ROWCOUNT =0
BEGIN Insert into System_User_Function (System_User_ID,System_Function_ID, Right_Type_ID, Store_ID) 
VALUES ((Select top(1) System_User_ID from [System_User] Where first_name=@fn and Surname=@sn AND Global_User_ID=@gu),4,1,1) 
END

Select * from System_User_Function Where system_user_id in (select system_user_id from [system_user] where first_name=@fn and Surname=@sn AND Global_User_ID=@gu and System_Function_ID = 5 and Right_Type_ID = 3);
if @@ROWCOUNT =0
BEGIN Insert into System_User_Function (System_User_ID,System_Function_ID, Right_Type_ID, Store_ID) 
VALUES ((Select top(1) System_User_ID from [System_User] Where first_name=@fn and Surname=@sn AND Global_User_ID=@gu),5,3,1) 
END

Select * from System_User_Function Where system_user_id in (select system_user_id from [system_user] where first_name=@fn and Surname=@sn AND Global_User_ID=@gu and System_Function_ID = 5  and Right_Type_ID = 4);
if @@ROWCOUNT =0
BEGIN Insert into System_User_Function (System_User_ID,System_Function_ID, Right_Type_ID, Store_ID) 
VALUES ((Select top(1) System_User_ID from [System_User] Where first_name=@fn and Surname=@sn AND Global_User_ID=@gu),5,4,1) 
END

Select * from System_User_Function Where system_user_id in (select system_user_id from [system_user] where first_name=@fn and Surname=@sn AND Global_User_ID=@gu and System_Function_ID = 6);
if @@ROWCOUNT =0
BEGIN Insert into System_User_Function (System_User_ID,System_Function_ID, Right_Type_ID, Store_ID) 
VALUES ((Select top(1) System_User_ID from [System_User] Where first_name=@fn and Surname=@sn AND Global_User_ID=@gu),6,4,1) 
END

Select * from System_User_Function Where system_user_id in (select system_user_id from [system_user] where first_name=@fn and Surname=@sn AND Global_User_ID=@gu and System_Function_ID = 9);
if @@ROWCOUNT =0
BEGIN Insert into System_User_Function (System_User_ID,System_Function_ID, Right_Type_ID, Store_ID) 
VALUES ((Select top(1) System_User_ID from [System_User] Where first_name=@fn and Surname=@sn AND Global_User_ID=@gu),9,5,1) 
END

Select * from System_User_Function Where system_user_id in (select system_user_id from [system_user] where first_name=@fn and Surname=@sn AND Global_User_ID=@gu and System_Function_ID = 10);
if @@ROWCOUNT =0
BEGIN Insert into System_User_Function (System_User_ID,System_Function_ID, Right_Type_ID, Store_ID) 
VALUES ((Select top(1) System_User_ID from [System_User] Where first_name=@fn and Surname=@sn AND Global_User_ID=@gu),10,5,1) 
END

Select * from System_User_Function Where system_user_id in (select system_user_id from [system_user] where first_name=@fn and Surname=@sn AND Global_User_ID=@gu and System_Function_ID = 11);
if @@ROWCOUNT =0
BEGIN Insert into System_User_Function (System_User_ID,System_Function_ID, Right_Type_ID, Store_ID) 
VALUES ((Select top(1) System_User_ID from [System_User] Where first_name=@fn and Surname=@sn AND Global_User_ID=@gu),11,1,1) 
END

Select * from System_User_Function Where system_user_id in (select system_user_id from [system_user] where first_name=@fn and Surname=@sn AND Global_User_ID=@gu and System_Function_ID = 12);
if @@ROWCOUNT =0
BEGIN Insert into System_User_Function (System_User_ID,System_Function_ID, Right_Type_ID, Store_ID) 
VALUES ((Select top(1) System_User_ID from [System_User] Where first_name=@fn and Surname=@sn AND Global_User_ID=@gu),12,1,1) 
END

Select * from System_User_Function Where system_user_id in (select system_user_id from [system_user] where first_name=@fn and Surname=@sn AND Global_User_ID=@gu and System_Function_ID = 13);
if @@ROWCOUNT =0
BEGIN Insert into System_User_Function (System_User_ID,System_Function_ID, Right_Type_ID, Store_ID) 
VALUES ((Select top(1) System_User_ID from [System_User] Where first_name=@fn and Surname=@sn AND Global_User_ID=@gu),13,3,1) 
END

Select * from System_User_Function Where system_user_id in (select system_user_id from [system_user] where first_name=@fn and Surname=@sn AND Global_User_ID=@gu and System_Function_ID = 14);
if @@ROWCOUNT =0
BEGIN Insert into System_User_Function (System_User_ID,System_Function_ID, Right_Type_ID, Store_ID) 
VALUES ((Select top(1) System_User_ID from [System_User] Where first_name=@fn and Surname=@sn AND Global_User_ID=@gu),14,5,1) 
END

Select * from System_User_Function Where system_user_id in (select system_user_id from [system_user] where first_name=@fn and Surname=@sn AND Global_User_ID=@gu and System_Function_ID = 15);
if @@ROWCOUNT =0
BEGIN Insert into System_User_Function (System_User_ID,System_Function_ID, Right_Type_ID, Store_ID) 
VALUES ((Select top(1) System_User_ID from [System_User] Where first_name=@fn and Surname=@sn AND Global_User_ID=@gu),15,5,1) 
END

Select * from System_User_Function Where system_user_id in (select system_user_id from [system_user] where first_name=@fn and Surname=@sn AND Global_User_ID=@gu and System_Function_ID = 16);
if @@ROWCOUNT =0
BEGIN Insert into System_User_Function (System_User_ID,System_Function_ID, Right_Type_ID, Store_ID) 
VALUES ((Select top(1) System_User_ID from [System_User] Where first_name=@fn and Surname=@sn AND Global_User_ID=@gu),16,5,1) 
END

Select * from System_User_Function Where system_user_id in (select system_user_id from [system_user] where first_name=@fn and Surname=@sn AND Global_User_ID=@gu and System_Function_ID = 17);
if @@ROWCOUNT =0
BEGIN Insert into System_User_Function (System_User_ID,System_Function_ID, Right_Type_ID, Store_ID) 
VALUES ((Select top(1) System_User_ID from [System_User] Where first_name=@fn and Surname=@sn AND Global_User_ID=@gu),17,5,1) 
END

Select * from System_User_Function Where system_user_id in (select system_user_id from [system_user] where first_name=@fn and Surname=@sn AND Global_User_ID=@gu and System_Function_ID = 18);
if @@ROWCOUNT =0
BEGIN Insert into System_User_Function (System_User_ID,System_Function_ID, Right_Type_ID, Store_ID) 
VALUES ((Select top(1) System_User_ID from [System_User] Where first_name=@fn and Surname=@sn AND Global_User_ID=@gu),18,5,1) 
END

Select * from System_User_Function Where system_user_id in (select system_user_id from [system_user] where first_name=@fn and Surname=@sn AND Global_User_ID=@gu and System_Function_ID = 19);
if @@ROWCOUNT =0
BEGIN Insert into System_User_Function (System_User_ID,System_Function_ID, Right_Type_ID, Store_ID) 
VALUES ((Select top(1) System_User_ID from [System_User] Where first_name=@fn and Surname=@sn AND Global_User_ID=@gu),19,5,1) 
END

Select * from System_User_Function Where system_user_id in (select system_user_id from [system_user] where first_name=@fn and Surname=@sn AND Global_User_ID=@gu and System_Function_ID = 21);
if @@ROWCOUNT =0
BEGIN Insert into System_User_Function (System_User_ID,System_Function_ID, Right_Type_ID, Store_ID) 
VALUES ((Select top(1) System_User_ID from [System_User] Where first_name=@fn and Surname=@sn AND Global_User_ID=@gu),21,5,1) 
END

Select * from System_User_Function Where system_user_id in (select system_user_id from [system_user] where first_name=@fn and Surname=@sn AND Global_User_ID=@gu and System_Function_ID = 22);
if @@ROWCOUNT =0
BEGIN Insert into System_User_Function (System_User_ID,System_Function_ID, Right_Type_ID, Store_ID) 
VALUES ((Select top(1) System_User_ID from [System_User] Where first_name=@fn and Surname=@sn AND Global_User_ID=@gu),22,5,1) 
END

Select * from System_User_Function Where system_user_id in (select system_user_id from [system_user] where first_name=@fn and Surname=@sn AND Global_User_ID=@gu and System_Function_ID = 23);
if @@ROWCOUNT =0
BEGIN Insert into System_User_Function (System_User_ID,System_Function_ID, Right_Type_ID, Store_ID) 
VALUES ((Select top(1) System_User_ID from [System_User] Where first_name=@fn and Surname=@sn AND Global_User_ID=@gu),23,5,1) 
END

Select * from System_User_Function Where system_user_id in (select system_user_id from [system_user] where first_name=@fn and Surname=@sn AND Global_User_ID=@gu and System_Function_ID = 26);
if @@ROWCOUNT =0
BEGIN Insert into System_User_Function (System_User_ID,System_Function_ID, Right_Type_ID, Store_ID) 
VALUES ((Select top(1) System_User_ID from [System_User] Where first_name=@fn and Surname=@sn AND Global_User_ID=@gu),26,1,1) 
END

Select * from System_User_Function Where system_user_id in (select system_user_id from [system_user] where first_name=@fn and Surname=@sn AND Global_User_ID=@gu and System_Function_ID = 27);
if @@ROWCOUNT =0
BEGIN Insert into System_User_Function (System_User_ID,System_Function_ID, Right_Type_ID, Store_ID) 
VALUES ((Select top(1) System_User_ID from [System_User] Where first_name=@fn and Surname=@sn AND Global_User_ID=@gu),27,1,1) 
END

Select * from System_User_Function Where system_user_id in (select system_user_id from [system_user] where first_name=@fn and Surname=@sn AND Global_User_ID=@gu and System_Function_ID = 28);
if @@ROWCOUNT =0
BEGIN Insert into System_User_Function (System_User_ID,System_Function_ID, Right_Type_ID, Store_ID) 
VALUES ((Select top(1) System_User_ID from [System_User] Where first_name=@fn and Surname=@sn AND Global_User_ID=@gu),28,5,1) 
END

Select * from System_User_Function Where system_user_id in (select system_user_id from [system_user] where first_name=@fn and Surname=@sn AND Global_User_ID=@gu and System_Function_ID = 29);
if @@ROWCOUNT =0
BEGIN Insert into System_User_Function (System_User_ID,System_Function_ID, Right_Type_ID, Store_ID) 
VALUES ((Select top(1) System_User_ID from [System_User] Where first_name=@fn and Surname=@sn AND Global_User_ID=@gu),29,5,1) 
END

Select * from System_User_Function Where system_user_id in (select system_user_id from [system_user] where first_name=@fn and Surname=@sn AND Global_User_ID=@gu and System_Function_ID = 30);
if @@ROWCOUNT =0
BEGIN Insert into System_User_Function (System_User_ID,System_Function_ID, Right_Type_ID, Store_ID) 
VALUES ((Select top(1) System_User_ID from [System_User] Where first_name=@fn and Surname=@sn AND Global_User_ID=@gu),30,1,1) 
END

Select * from System_User_Function Where system_user_id in (select system_user_id from [system_user] where first_name=@fn and Surname=@sn AND Global_User_ID=@gu and System_Function_ID = 31);
if @@ROWCOUNT =0
BEGIN Insert into System_User_Function (System_User_ID,System_Function_ID, Right_Type_ID, Store_ID) 
VALUES ((Select top(1) System_User_ID from [System_User] Where first_name=@fn and Surname=@sn AND Global_User_ID=@gu),31,1,1) 
END

Select * from System_User_Function Where system_user_id in (select system_user_id from [system_user] where first_name=@fn and Surname=@sn AND Global_User_ID=@gu and System_Function_ID = 32);
if @@ROWCOUNT =0
BEGIN Insert into System_User_Function (System_User_ID,System_Function_ID, Right_Type_ID, Store_ID) 
VALUES ((Select top(1) System_User_ID from [System_User] Where first_name=@fn and Surname=@sn AND Global_User_ID=@gu),32,5,1) 
END

Select * from System_User_Function Where system_user_id in (select system_user_id from [system_user] where first_name=@fn and Surname=@sn AND Global_User_ID=@gu and System_Function_ID = 33);
if @@ROWCOUNT =0
BEGIN Insert into System_User_Function (System_User_ID,System_Function_ID, Right_Type_ID, Store_ID) 
VALUES ((Select top(1) System_User_ID from [System_User] Where first_name=@fn and Surname=@sn AND Global_User_ID=@gu),33,1,1) 
END

Select * from System_User_Function Where system_user_id in (select system_user_id from [system_user] where first_name=@fn and Surname=@sn AND Global_User_ID=@gu and System_Function_ID = 34);
if @@ROWCOUNT =0
BEGIN Insert into System_User_Function (System_User_ID,System_Function_ID, Right_Type_ID, Store_ID) 
VALUES ((Select top(1) System_User_ID from [System_User] Where first_name=@fn and Surname=@sn AND Global_User_ID=@gu),34,5,1) 
END

Select * from System_User_Function Where system_user_id in (select system_user_id from [system_user] where first_name=@fn and Surname=@sn AND Global_User_ID=@gu and System_Function_ID = 35);
if @@ROWCOUNT =0
BEGIN Insert into System_User_Function (System_User_ID,System_Function_ID, Right_Type_ID, Store_ID) 
VALUES ((Select top(1) System_User_ID from [System_User] Where first_name=@fn and Surname=@sn AND Global_User_ID=@gu),35,5,1) 
END

Select * from System_User_Function Where system_user_id in (select system_user_id from [system_user] where first_name=@fn and Surname=@sn AND Global_User_ID=@gu and System_Function_ID = 36);
if @@ROWCOUNT =0
BEGIN Insert into System_User_Function (System_User_ID,System_Function_ID, Right_Type_ID, Store_ID) 
VALUES ((Select top(1) System_User_ID from [System_User] Where first_name=@fn and Surname=@sn AND Global_User_ID=@gu),36,3,1) 
END

Select * from System_User_Function Where system_user_id in (select system_user_id from [system_user] where first_name=@fn and Surname=@sn AND Global_User_ID=@gu and System_Function_ID = 37);
if @@ROWCOUNT =0
BEGIN Insert into System_User_Function (System_User_ID,System_Function_ID, Right_Type_ID, Store_ID) 
VALUES ((Select top(1) System_User_ID from [System_User] Where first_name=@fn and Surname=@sn AND Global_User_ID=@gu),37,5,1) 
END

Select * from System_User_Function Where system_user_id in (select system_user_id from [system_user] where first_name=@fn and Surname=@sn AND Global_User_ID=@gu and System_Function_ID = 38);
if @@ROWCOUNT =0
BEGIN Insert into System_User_Function (System_User_ID,System_Function_ID, Right_Type_ID, Store_ID) 
VALUES ((Select top(1) System_User_ID from [System_User] Where first_name=@fn and Surname=@sn AND Global_User_ID=@gu),38,5,1) 
END

Select * from System_User_Function Where system_user_id in (select system_user_id from [system_user] where first_name=@fn and Surname=@sn AND Global_User_ID=@gu and System_Function_ID = 43);
if @@ROWCOUNT =0
BEGIN Insert into System_User_Function (System_User_ID,System_Function_ID, Right_Type_ID, Store_ID) 
VALUES ((Select top(1) System_User_ID from [System_User] Where first_name=@fn and Surname=@sn AND Global_User_ID=@gu),43,4,1) 
END

Select * from System_User_Function Where system_user_id in (select system_user_id from [system_user] where first_name=@fn and Surname=@sn AND Global_User_ID=@gu and System_Function_ID = 44);
if @@ROWCOUNT =0
BEGIN Insert into System_User_Function (System_User_ID,System_Function_ID, Right_Type_ID, Store_ID) 
VALUES ((Select top(1) System_User_ID from [System_User] Where first_name=@fn and Surname=@sn AND Global_User_ID=@gu),44,5,1) 
END

Select * from System_User_Function Where system_user_id in (select system_user_id from [system_user] where first_name=@fn and Surname=@sn AND Global_User_ID=@gu and System_Function_ID = 45);
if @@ROWCOUNT =0
BEGIN Insert into System_User_Function (System_User_ID,System_Function_ID, Right_Type_ID, Store_ID) 
VALUES ((Select top(1) System_User_ID from [System_User] Where first_name=@fn and Surname=@sn AND Global_User_ID=@gu),45,5,1) 
END

Select * from System_User_Function Where system_user_id in (select system_user_id from [system_user] where first_name=@fn and Surname=@sn AND Global_User_ID=@gu and System_Function_ID = 47);
if @@ROWCOUNT =0
BEGIN Insert into System_User_Function (System_User_ID,System_Function_ID, Right_Type_ID, Store_ID) 
VALUES ((Select top(1) System_User_ID from [System_User] Where first_name=@fn and Surname=@sn AND Global_User_ID=@gu),47,5,1) 
END

Select * from System_User_Function Where system_user_id in (select system_user_id from [system_user] where first_name=@fn and Surname=@sn AND Global_User_ID=@gu and System_Function_ID = 48);
if @@ROWCOUNT =0
BEGIN Insert into System_User_Function (System_User_ID,System_Function_ID, Right_Type_ID, Store_ID) 
VALUES ((Select top(1) System_User_ID from [System_User] Where first_name=@fn and Surname=@sn AND Global_User_ID=@gu),48,5,1) 
END

Select * from System_User_Function Where system_user_id in (select system_user_id from [system_user] where first_name=@fn and Surname=@sn AND Global_User_ID=@gu and System_Function_ID = 49);
if @@ROWCOUNT =0
BEGIN Insert into System_User_Function (System_User_ID,System_Function_ID, Right_Type_ID, Store_ID) 
VALUES ((Select top(1) System_User_ID from [System_User] Where first_name=@fn and Surname=@sn AND Global_User_ID=@gu),49,1,1) 
END

Select * from System_User_Function Where system_user_id in (select system_user_id from [system_user] where first_name=@fn and Surname=@sn AND Global_User_ID=@gu and System_Function_ID = 50);
if @@ROWCOUNT =0
BEGIN Insert into System_User_Function (System_User_ID,System_Function_ID, Right_Type_ID, Store_ID) 
VALUES ((Select top(1) System_User_ID from [System_User] Where first_name=@fn and Surname=@sn AND Global_User_ID=@gu),50,5,1) 
END

Select * from System_User_Function Where system_user_id in (select system_user_id from [system_user] where first_name=@fn and Surname=@sn AND Global_User_ID=@gu and System_Function_ID = 51);
if @@ROWCOUNT =0
BEGIN Insert into System_User_Function (System_User_ID,System_Function_ID, Right_Type_ID, Store_ID) 
VALUES ((Select top(1) System_User_ID from [System_User] Where first_name=@fn and Surname=@sn AND Global_User_ID=@gu),51,5,1) 
END

Select * from System_User_Function Where system_user_id in (select system_user_id from [system_user] where first_name=@fn and Surname=@sn AND Global_User_ID=@gu and System_Function_ID = 52);
if @@ROWCOUNT =0
BEGIN Insert into System_User_Function (System_User_ID,System_Function_ID, Right_Type_ID, Store_ID) 
VALUES ((Select top(1) System_User_ID from [System_User] Where first_name=@fn and Surname=@sn AND Global_User_ID=@gu),52,5,1) 
END

Select * from System_User_Function Where system_user_id in (select system_user_id from [system_user] where first_name=@fn and Surname=@sn AND Global_User_ID=@gu and System_Function_ID = 53);
if @@ROWCOUNT =0
BEGIN Insert into System_User_Function (System_User_ID,System_Function_ID, Right_Type_ID, Store_ID) 
VALUES ((Select top(1) System_User_ID from [System_User] Where first_name=@fn and Surname=@sn AND Global_User_ID=@gu),53,3,1) 
END

Select * from System_User_Function Where system_user_id in (select system_user_id from [system_user] where first_name=@fn and Surname=@sn AND Global_User_ID=@gu and System_Function_ID = 54);
if @@ROWCOUNT =0
BEGIN Insert into System_User_Function (System_User_ID,System_Function_ID, Right_Type_ID, Store_ID) 
VALUES ((Select top(1) System_User_ID from [System_User] Where first_name=@fn and Surname=@sn AND Global_User_ID=@gu),54,5,1) 
END

Select * from System_User_Function Where system_user_id in (select system_user_id from [system_user] where first_name=@fn and Surname=@sn AND Global_User_ID=@gu and System_Function_ID = 56);
if @@ROWCOUNT =0
BEGIN Insert into System_User_Function (System_User_ID,System_Function_ID, Right_Type_ID, Store_ID) 
VALUES ((Select top(1) System_User_ID from [System_User] Where first_name=@fn and Surname=@sn AND Global_User_ID=@gu),56,4,1) 
END

Select * from System_User_Function Where system_user_id in (select system_user_id from [system_user] where first_name=@fn and Surname=@sn AND Global_User_ID=@gu and System_Function_ID = 57);
if @@ROWCOUNT =0
BEGIN Insert into System_User_Function (System_User_ID,System_Function_ID, Right_Type_ID, Store_ID) 
VALUES ((Select top(1) System_User_ID from [System_User] Where first_name=@fn and Surname=@sn AND Global_User_ID=@gu),57,4,1) 
END

Select * from System_User_Function Where system_user_id in (select system_user_id from [system_user] where first_name=@fn and Surname=@sn AND Global_User_ID=@gu and System_Function_ID = 58);
if @@ROWCOUNT =0
BEGIN Insert into System_User_Function (System_User_ID,System_Function_ID, Right_Type_ID, Store_ID) 
VALUES ((Select top(1) System_User_ID from [System_User] Where first_name=@fn and Surname=@sn AND Global_User_ID=@gu),58,5,1) 
END

Select * from System_User_Function Where system_user_id in (select system_user_id from [system_user] where first_name=@fn and Surname=@sn AND Global_User_ID=@gu and System_Function_ID = 60);
if @@ROWCOUNT =0
BEGIN Insert into System_User_Function (System_User_ID,System_Function_ID, Right_Type_ID, Store_ID) 
VALUES ((Select top(1) System_User_ID from [System_User] Where first_name=@fn and Surname=@sn AND Global_User_ID=@gu),60,5,1) 
END

Select * from System_User_Function Where system_user_id in (select system_user_id from [system_user] where first_name=@fn and Surname=@sn AND Global_User_ID=@gu and System_Function_ID = 61);
if @@ROWCOUNT =0
BEGIN Insert into System_User_Function (System_User_ID,System_Function_ID, Right_Type_ID, Store_ID) 
VALUES ((Select top(1) System_User_ID from [System_User] Where first_name=@fn and Surname=@sn AND Global_User_ID=@gu),61,5,1) 
END

Select * from System_User_Function Where system_user_id in (select system_user_id from [system_user] where first_name=@fn and Surname=@sn AND Global_User_ID=@gu and System_Function_ID = 62);
if @@ROWCOUNT =0
BEGIN Insert into System_User_Function (System_User_ID,System_Function_ID, Right_Type_ID, Store_ID) 
VALUES ((Select top(1) System_User_ID from [System_User] Where first_name=@fn and Surname=@sn AND Global_User_ID=@gu),62,5,1) 
END

Select * from System_User_Function Where system_user_id in (select system_user_id from [system_user] where first_name=@fn and Surname=@sn AND Global_User_ID=@gu and System_Function_ID = 63);
if @@ROWCOUNT =0
BEGIN Insert into System_User_Function (System_User_ID,System_Function_ID, Right_Type_ID, Store_ID) 
VALUES ((Select top(1) System_User_ID from [System_User] Where first_name=@fn and Surname=@sn AND Global_User_ID=@gu),63,5,1) 
END

Select * from System_User_Function Where system_user_id in (select system_user_id from [system_user] where first_name=@fn and Surname=@sn AND Global_User_ID=@gu and System_Function_ID = 64);
if @@ROWCOUNT =0
BEGIN Insert into System_User_Function (System_User_ID,System_Function_ID, Right_Type_ID, Store_ID) 
VALUES ((Select top(1) System_User_ID from [System_User] Where first_name=@fn and Surname=@sn AND Global_User_ID=@gu),64,5,1) 
END

Select * from System_User_Function Where system_user_id in (select system_user_id from [system_user] where first_name=@fn and Surname=@sn AND Global_User_ID=@gu and System_Function_ID = 65);
if @@ROWCOUNT =0
BEGIN Insert into System_User_Function (System_User_ID,System_Function_ID, Right_Type_ID, Store_ID) 
VALUES ((Select top(1) System_User_ID from [System_User] Where first_name=@fn and Surname=@sn AND Global_User_ID=@gu),65,1,1) 
END

Select * from System_User_Function Where system_user_id in (select system_user_id from [system_user] where first_name=@fn and Surname=@sn AND Global_User_ID=@gu and System_Function_ID = 66);
if @@ROWCOUNT =0
BEGIN Insert into System_User_Function (System_User_ID,System_Function_ID, Right_Type_ID, Store_ID) 
VALUES ((Select top(1) System_User_ID from [System_User] Where first_name=@fn and Surname=@sn AND Global_User_ID=@gu),66,1,1) 
END

Select * from System_User_Function Where system_user_id in (select system_user_id from [system_user] where first_name=@fn and Surname=@sn AND Global_User_ID=@gu and System_Function_ID = 67);
if @@ROWCOUNT =0
BEGIN Insert into System_User_Function (System_User_ID,System_Function_ID, Right_Type_ID, Store_ID) 
VALUES ((Select top(1) System_User_ID from [System_User] Where first_name=@fn and Surname=@sn AND Global_User_ID=@gu),67,5,1) 
END

Select * from System_User_Function Where system_user_id in (select system_user_id from [system_user] where first_name=@fn and Surname=@sn AND Global_User_ID=@gu and System_Function_ID = 68);
if @@ROWCOUNT =0
BEGIN Insert into System_User_Function (System_User_ID,System_Function_ID, Right_Type_ID, Store_ID) 
VALUES ((Select top(1) System_User_ID from [System_User] Where first_name=@fn and Surname=@sn AND Global_User_ID=@gu),68,5,1) 
END

Select * from System_User_Function Where system_user_id in (select system_user_id from [system_user] where first_name=@fn and Surname=@sn AND Global_User_ID=@gu and System_Function_ID = 69);
if @@ROWCOUNT =0
BEGIN Insert into System_User_Function (System_User_ID,System_Function_ID, Right_Type_ID, Store_ID) 
VALUES ((Select top(1) System_User_ID from [System_User] Where first_name=@fn and Surname=@sn AND Global_User_ID=@gu),69,1,1) 
END

Select * from System_User_Function Where system_user_id in (select system_user_id from [system_user] where first_name=@fn and Surname=@sn AND Global_User_ID=@gu and System_Function_ID = 70);
if @@ROWCOUNT =0
BEGIN Insert into System_User_Function (System_User_ID,System_Function_ID, Right_Type_ID, Store_ID) 
VALUES ((Select top(1) System_User_ID from [System_User] Where first_name=@fn and Surname=@sn AND Global_User_ID=@gu),70,1,1) 
END

Select * from System_User_Function Where system_user_id in (select system_user_id from [system_user] where first_name=@fn and Surname=@sn AND Global_User_ID=@gu and System_Function_ID = 71);
if @@ROWCOUNT =0
BEGIN Insert into System_User_Function (System_User_ID,System_Function_ID, Right_Type_ID, Store_ID) 
VALUES ((Select top(1) System_User_ID from [System_User] Where first_name=@fn and Surname=@sn AND Global_User_ID=@gu),71,5,1) 
END

Select * from System_User_Function Where system_user_id in (select system_user_id from [system_user] where first_name=@fn and Surname=@sn AND Global_User_ID=@gu and System_Function_ID = 72);
if @@ROWCOUNT =0
BEGIN Insert into System_User_Function (System_User_ID,System_Function_ID, Right_Type_ID, Store_ID) 
VALUES ((Select top(1) System_User_ID from [System_User] Where first_name=@fn and Surname=@sn AND Global_User_ID=@gu),72,1,1) 
END

Select * from System_User_Function Where system_user_id in (select system_user_id from [system_user] where first_name=@fn and Surname=@sn AND Global_User_ID=@gu and System_Function_ID = 73);
if @@ROWCOUNT =0
BEGIN Insert into System_User_Function (System_User_ID,System_Function_ID, Right_Type_ID, Store_ID) 
VALUES ((Select top(1) System_User_ID from [System_User] Where first_name=@fn and Surname=@sn AND Global_User_ID=@gu),73,1,1) 
END

Select * from System_User_Function Where system_user_id in (select system_user_id from [system_user] where first_name=@fn and Surname=@sn AND Global_User_ID=@gu and System_Function_ID = 74);
if @@ROWCOUNT =0
BEGIN Insert into System_User_Function (System_User_ID,System_Function_ID, Right_Type_ID, Store_ID) 
VALUES ((Select top(1) System_User_ID from [System_User] Where first_name=@fn and Surname=@sn AND Global_User_ID=@gu),74,4,1) 
END

Select * from System_User_Function Where system_user_id in (select system_user_id from [system_user] where first_name=@fn and Surname=@sn AND Global_User_ID=@gu and System_Function_ID = 75);
if @@ROWCOUNT =0
BEGIN Insert into System_User_Function (System_User_ID,System_Function_ID, Right_Type_ID, Store_ID) 
VALUES ((Select top(1) System_User_ID from [System_User] Where first_name=@fn and Surname=@sn AND Global_User_ID=@gu),75,5,1) 
END

Select * from System_User_Function Where system_user_id in (select system_user_id from [system_user] where first_name=@fn and Surname=@sn AND Global_User_ID=@gu and System_Function_ID = 76);
if @@ROWCOUNT =0
BEGIN Insert into System_User_Function (System_User_ID,System_Function_ID, Right_Type_ID, Store_ID) 
VALUES ((Select top(1) System_User_ID from [System_User] Where first_name=@fn and Surname=@sn AND Global_User_ID=@gu),76,5,1) 
END

Select * from System_User_Function Where system_user_id in (select system_user_id from [system_user] where first_name=@fn and Surname=@sn AND Global_User_ID=@gu and System_Function_ID = 77);
if @@ROWCOUNT =0
BEGIN Insert into System_User_Function (System_User_ID,System_Function_ID, Right_Type_ID, Store_ID) 
VALUES ((Select top(1) System_User_ID from [System_User] Where first_name=@fn and Surname=@sn AND Global_User_ID=@gu),77,5,1) 
END

Select * from System_User_Function Where system_user_id in (select system_user_id from [system_user] where first_name=@fn and Surname=@sn AND Global_User_ID=@gu and System_Function_ID = 79);
if @@ROWCOUNT =0
BEGIN Insert into System_User_Function (System_User_ID,System_Function_ID, Right_Type_ID, Store_ID) 
VALUES ((Select top(1) System_User_ID from [System_User] Where first_name=@fn and Surname=@sn AND Global_User_ID=@gu),79,5,1) 
END

Select * from System_User_Function Where system_user_id in (select system_user_id from [system_user] where first_name=@fn and Surname=@sn AND Global_User_ID=@gu and System_Function_ID = 80);
if @@ROWCOUNT =0
BEGIN Insert into System_User_Function (System_User_ID,System_Function_ID, Right_Type_ID, Store_ID) 
VALUES ((Select top(1) System_User_ID from [System_User] Where first_name=@fn and Surname=@sn AND Global_User_ID=@gu),80,5,1) 
END

Select * from System_User_Function Where system_user_id in (select system_user_id from [system_user] where first_name=@fn and Surname=@sn AND Global_User_ID=@gu and System_Function_ID = 81);
if @@ROWCOUNT =0
BEGIN Insert into System_User_Function (System_User_ID,System_Function_ID, Right_Type_ID, Store_ID) 
VALUES ((Select top(1) System_User_ID from [System_User] Where first_name=@fn and Surname=@sn AND Global_User_ID=@gu),81,4,1) 
END

Select * from System_User_Function Where system_user_id in (select system_user_id from [system_user] where first_name=@fn and Surname=@sn AND Global_User_ID=@gu and System_Function_ID = 84);
if @@ROWCOUNT =0
BEGIN Insert into System_User_Function (System_User_ID,System_Function_ID, Right_Type_ID, Store_ID) 
VALUES ((Select top(1) System_User_ID from [System_User] Where first_name=@fn and Surname=@sn AND Global_User_ID=@gu),84,4,1) 
END

Select * from System_User_Function Where system_user_id in (select system_user_id from [system_user] where first_name=@fn and Surname=@sn AND Global_User_ID=@gu and System_Function_ID = 85);
if @@ROWCOUNT =0
BEGIN Insert into System_User_Function (System_User_ID,System_Function_ID, Right_Type_ID, Store_ID) 
VALUES ((Select top(1) System_User_ID from [System_User] Where first_name=@fn and Surname=@sn AND Global_User_ID=@gu),85,4,1) 
END

Select * from System_User_Function Where system_user_id in (select system_user_id from [system_user] where first_name=@fn and Surname=@sn AND Global_User_ID=@gu and System_Function_ID = 86);
if @@ROWCOUNT =0
BEGIN Insert into System_User_Function (System_User_ID,System_Function_ID, Right_Type_ID, Store_ID) 
VALUES ((Select top(1) System_User_ID from [System_User] Where first_name=@fn and Surname=@sn AND Global_User_ID=@gu),86,1,1) 
END

Select * from System_User_Function Where system_user_id in (select system_user_id from [system_user] where first_name=@fn and Surname=@sn AND Global_User_ID=@gu and System_Function_ID = 87);
if @@ROWCOUNT =0
BEGIN Insert into System_User_Function (System_User_ID,System_Function_ID, Right_Type_ID, Store_ID) 
VALUES ((Select top(1) System_User_ID from [System_User] Where first_name=@fn and Surname=@sn AND Global_User_ID=@gu),87,4,1) 
END

Select * from System_User_Function Where system_user_id in (select system_user_id from [system_user] where first_name=@fn and Surname=@sn AND Global_User_ID=@gu and System_Function_ID = 88);
if @@ROWCOUNT =0
BEGIN Insert into System_User_Function (System_User_ID,System_Function_ID, Right_Type_ID, Store_ID) 
VALUES ((Select top(1) System_User_ID from [System_User] Where first_name=@fn and Surname=@sn AND Global_User_ID=@gu),88,4,1) 
END

Select * from System_User_Function Where system_user_id in (select system_user_id from [system_user] where first_name=@fn and Surname=@sn AND Global_User_ID=@gu and System_Function_ID = 90);
if @@ROWCOUNT =0
BEGIN Insert into System_User_Function (System_User_ID,System_Function_ID, Right_Type_ID, Store_ID) 
VALUES ((Select top(1) System_User_ID from [System_User] Where first_name=@fn and Surname=@sn AND Global_User_ID=@gu),90,4,1) 
END

Select * from System_User_Function Where system_user_id in (select system_user_id from [system_user] where first_name=@fn and Surname=@sn AND Global_User_ID=@gu and System_Function_ID = 91);
if @@ROWCOUNT =0
BEGIN Insert into System_User_Function (System_User_ID,System_Function_ID, Right_Type_ID, Store_ID) 
VALUES ((Select top(1) System_User_ID from [System_User] Where first_name=@fn and Surname=@sn AND Global_User_ID=@gu),91,1,1) 
END

Select * from System_User_Function Where system_user_id in (select system_user_id from [system_user] where first_name=@fn and Surname=@sn AND Global_User_ID=@gu and System_Function_ID = 92);
if @@ROWCOUNT =0
BEGIN Insert into System_User_Function (System_User_ID,System_Function_ID, Right_Type_ID, Store_ID) 
VALUES ((Select top(1) System_User_ID from [System_User] Where first_name=@fn and Surname=@sn AND Global_User_ID=@gu),92,1,1) 
END

Select * from System_User_Function Where system_user_id in (select system_user_id from [system_user] where first_name=@fn and Surname=@sn AND Global_User_ID=@gu and System_Function_ID = 93);
if @@ROWCOUNT =0
BEGIN Insert into System_User_Function (System_User_ID,System_Function_ID, Right_Type_ID, Store_ID) 
VALUES ((Select top(1) System_User_ID from [System_User] Where first_name=@fn and Surname=@sn AND Global_User_ID=@gu),93,1,1) 
END

Select * from System_User_Function Where system_user_id in (select system_user_id from [system_user] where first_name=@fn and Surname=@sn AND Global_User_ID=@gu and System_Function_ID = 94);
if @@ROWCOUNT =0
BEGIN Insert into System_User_Function (System_User_ID,System_Function_ID, Right_Type_ID, Store_ID) 
VALUES ((Select top(1) System_User_ID from [System_User] Where first_name=@fn and Surname=@sn AND Global_User_ID=@gu),94,1,1) 
END

Select * from System_User_Function Where system_user_id in (select system_user_id from [system_user] where first_name=@fn and Surname=@sn AND Global_User_ID=@gu and System_Function_ID = 95);
if @@ROWCOUNT =0
BEGIN Insert into System_User_Function (System_User_ID,System_Function_ID, Right_Type_ID, Store_ID) 
VALUES ((Select top(1) System_User_ID from [System_User] Where first_name=@fn and Surname=@sn AND Global_User_ID=@gu),95,1,1) 
END

Select * from System_User_Function Where system_user_id in (select system_user_id from [system_user] where first_name=@fn and Surname=@sn AND Global_User_ID=@gu and System_Function_ID = 96);
if @@ROWCOUNT =0
BEGIN Insert into System_User_Function (System_User_ID,System_Function_ID, Right_Type_ID, Store_ID) 
VALUES ((Select top(1) System_User_ID from [System_User] Where first_name=@fn and Surname=@sn AND Global_User_ID=@gu),96,4,1) 
END

Select * from System_User_Function Where system_user_id in (select system_user_id from [system_user] where first_name=@fn and Surname=@sn AND Global_User_ID=@gu and System_Function_ID = 97);
if @@ROWCOUNT =0
BEGIN Insert into System_User_Function (System_User_ID,System_Function_ID, Right_Type_ID, Store_ID) 
VALUES ((Select top(1) System_User_ID from [System_User] Where first_name=@fn and Surname=@sn AND Global_User_ID=@gu),97,1,1) 
END

Select * from System_User_Function Where system_user_id in (select system_user_id from [system_user] where first_name=@fn and Surname=@sn AND Global_User_ID=@gu and System_Function_ID = 99);
if @@ROWCOUNT =0
BEGIN Insert into System_User_Function (System_User_ID,System_Function_ID, Right_Type_ID, Store_ID) 
VALUES ((Select top(1) System_User_ID from [System_User] Where first_name=@fn and Surname=@sn AND Global_User_ID=@gu),99,5,1) 
END

Select * from System_User_Function Where system_user_id in (select system_user_id from [system_user] where first_name=@fn and Surname=@sn AND Global_User_ID=@gu and System_Function_ID = 100);
if @@ROWCOUNT =0
BEGIN Insert into System_User_Function (System_User_ID,System_Function_ID, Right_Type_ID, Store_ID) 
VALUES ((Select top(1) System_User_ID from [System_User] Where first_name=@fn and Surname=@sn AND Global_User_ID=@gu),100,5,1) 
END

Select * from System_User_Function Where system_user_id in (select system_user_id from [system_user] where first_name=@fn and Surname=@sn AND Global_User_ID=@gu and System_Function_ID = 101);
if @@ROWCOUNT =0
BEGIN Insert into System_User_Function (System_User_ID,System_Function_ID, Right_Type_ID, Store_ID) 
VALUES ((Select top(1) System_User_ID from [System_User] Where first_name=@fn and Surname=@sn AND Global_User_ID=@gu),101,1,1) 
END

Select * from System_User_Function Where system_user_id in (select system_user_id from [system_user] where first_name=@fn and Surname=@sn AND Global_User_ID=@gu and System_Function_ID = 102 and Right_type_id = 1);
if @@ROWCOUNT =0
BEGIN Insert into System_User_Function (System_User_ID,System_Function_ID, Right_Type_ID, Store_ID) 
VALUES ((Select top(1) System_User_ID from [System_User] Where first_name=@fn and Surname=@sn AND Global_User_ID=@gu),102,1,1) 
END

Select * from System_User_Function Where system_user_id in (select system_user_id from [system_user] where first_name=@fn and Surname=@sn AND Global_User_ID=@gu and System_Function_ID = 102);
if @@ROWCOUNT =0
BEGIN Insert into System_User_Function (System_User_ID,System_Function_ID, Right_Type_ID, Store_ID) 
VALUES ((Select top(1) System_User_ID from [System_User] Where first_name=@fn and Surname=@sn AND Global_User_ID=@gu),102,4,1) 
END

Select * from System_User_Function Where system_user_id in (select system_user_id from [system_user] where first_name=@fn and Surname=@sn AND Global_User_ID=@gu and System_Function_ID = 103);
if @@ROWCOUNT =0
BEGIN Insert into System_User_Function (System_User_ID,System_Function_ID, Right_Type_ID, Store_ID) 
VALUES ((Select top(1) System_User_ID from [System_User] Where first_name=@fn and Surname=@sn AND Global_User_ID=@gu),103,4,1) 
END

Select * from System_User_Function Where system_user_id in (select system_user_id from [system_user] where first_name=@fn and Surname=@sn AND Global_User_ID=@gu and System_Function_ID = 104);
if @@ROWCOUNT =0
BEGIN Insert into System_User_Function (System_User_ID,System_Function_ID, Right_Type_ID, Store_ID) 
VALUES ((Select top(1) System_User_ID from [System_User] Where first_name=@fn and Surname=@sn AND Global_User_ID=@gu),104,5,1) 
END

Select * from System_User_Function Where system_user_id in (select system_user_id from [system_user] where first_name=@fn and Surname=@sn AND Global_User_ID=@gu and System_Function_ID = 105);
if @@ROWCOUNT =0
BEGIN Insert into System_User_Function (System_User_ID,System_Function_ID, Right_Type_ID, Store_ID) 
VALUES ((Select top(1) System_User_ID from [System_User] Where first_name=@fn and Surname=@sn AND Global_User_ID=@gu),105,5,1) 
END

Select * from System_User_Function Where system_user_id in (select system_user_id from [system_user] where first_name=@fn and Surname=@sn AND Global_User_ID=@gu and System_Function_ID = 106 ) ;
if @@ROWCOUNT =0
BEGIN Insert into System_User_Function (System_User_ID,System_Function_ID, Right_Type_ID, Store_ID) 
VALUES ((Select top(1) System_User_ID from [System_User] Where first_name=@fn and Surname=@sn AND Global_User_ID=@gu),106,5,1) 
END

Select * from System_User_Function Where system_user_id in (select system_user_id from [system_user] where first_name=@fn and Surname=@sn AND Global_User_ID=@gu and System_Function_ID = 107);
if @@ROWCOUNT =0
BEGIN Insert into System_User_Function (System_User_ID,System_Function_ID, Right_Type_ID, Store_ID) 
VALUES ((Select top(1) System_User_ID from [System_User] Where first_name=@fn and Surname=@sn AND Global_User_ID=@gu),107,4,1) 
END

Select * from System_User_Function Where system_user_id in (select system_user_id from [system_user] where first_name=@fn and Surname=@sn AND Global_User_ID=@gu and System_Function_ID = 108);
if @@ROWCOUNT =0
BEGIN Insert into System_User_Function (System_User_ID,System_Function_ID, Right_Type_ID, Store_ID) 
VALUES ((Select top(1) System_User_ID from [System_User] Where first_name=@fn and Surname=@sn AND Global_User_ID=@gu),108,4,1) 
END

Select * from System_User_Function Where system_user_id in (select system_user_id from [system_user] where first_name=@fn and Surname=@sn AND Global_User_ID=@gu and System_Function_ID = 109);
if @@ROWCOUNT =0
BEGIN Insert into System_User_Function (System_User_ID,System_Function_ID, Right_Type_ID, Store_ID) 
VALUES ((Select top(1) System_User_ID from [System_User] Where first_name=@fn and Surname=@sn AND Global_User_ID=@gu),109,4,1) 
END

Select * from System_User_Function Where system_user_id in (select system_user_id from [system_user] where first_name=@fn and Surname=@sn AND Global_User_ID=@gu and System_Function_ID = 110);
if @@ROWCOUNT =0
BEGIN Insert into System_User_Function (System_User_ID,System_Function_ID, Right_Type_ID, Store_ID) 
VALUES ((Select top(1) System_User_ID from [System_User] Where first_name=@fn and Surname=@sn AND Global_User_ID=@gu),110,4,1) 
END

Select * from System_User_Function Where system_user_id in (select system_user_id from [system_user] where first_name=@fn and Surname=@sn AND Global_User_ID=@gu and System_Function_ID = 111);
if @@ROWCOUNT =0
BEGIN Insert into System_User_Function (System_User_ID,System_Function_ID, Right_Type_ID, Store_ID) 
VALUES ((Select top(1) System_User_ID from [System_User] Where first_name=@fn and Surname=@sn AND Global_User_ID=@gu),111,5,1) 
END

Select * from System_User_Function Where system_user_id in (select system_user_id from [system_user] where first_name=@fn and Surname=@sn AND Global_User_ID=@gu and System_Function_ID = 112);
if @@ROWCOUNT =0
BEGIN Insert into System_User_Function (System_User_ID,System_Function_ID, Right_Type_ID, Store_ID) 
VALUES ((Select top(1) System_User_ID from [System_User] Where first_name=@fn and Surname=@sn AND Global_User_ID=@gu),112,4,1) 
END

Select * from System_User_Function Where system_user_id in (select system_user_id from [system_user] where first_name=@fn and Surname=@sn AND Global_User_ID=@gu and System_Function_ID = 114);
if @@ROWCOUNT =0
BEGIN Insert into System_User_Function (System_User_ID,System_Function_ID, Right_Type_ID, Store_ID) 
VALUES ((Select top(1) System_User_ID from [System_User] Where first_name=@fn and Surname=@sn AND Global_User_ID=@gu),114,5,1) 
END

Select * from System_User_Function Where system_user_id in (select system_user_id from [system_user] where first_name=@fn and Surname=@sn AND Global_User_ID=@gu and System_Function_ID = 119);
if @@ROWCOUNT =0
BEGIN Insert into System_User_Function (System_User_ID,System_Function_ID, Right_Type_ID, Store_ID) 
VALUES ((Select top(1) System_User_ID from [System_User] Where first_name=@fn and Surname=@sn AND Global_User_ID=@gu),119,5,1) 
END

Select * from System_User_Function Where system_user_id in (select system_user_id from [system_user] where first_name=@fn and Surname=@sn AND Global_User_ID=@gu and System_Function_ID = 120);
if @@ROWCOUNT =0
BEGIN Insert into System_User_Function (System_User_ID,System_Function_ID, Right_Type_ID, Store_ID) 
VALUES ((Select top(1) System_User_ID from [System_User] Where first_name=@fn and Surname=@sn AND Global_User_ID=@gu),120,5,1) 
END

Select * from System_User_Function Where system_user_id in (select system_user_id from [system_user] where first_name=@fn and Surname=@sn AND Global_User_ID=@gu and System_Function_ID = 121);
if @@ROWCOUNT =0
BEGIN Insert into System_User_Function (System_User_ID,System_Function_ID, Right_Type_ID, Store_ID) 
VALUES ((Select top(1) System_User_ID from [System_User] Where first_name=@fn and Surname=@sn AND Global_User_ID=@gu),121,4,1) 
END

Select * from System_User_Function Where system_user_id in (select system_user_id from [system_user] where first_name=@fn and Surname=@sn AND Global_User_ID=@gu and System_Function_ID = 122);
if @@ROWCOUNT =0
BEGIN Insert into System_User_Function (System_User_ID,System_Function_ID, Right_Type_ID, Store_ID) 
VALUES ((Select top(1) System_User_ID from [System_User] Where first_name=@fn and Surname=@sn AND Global_User_ID=@gu),122,4,1) 
END

Select * from System_User_Function Where system_user_id in (select system_user_id from [system_user] where first_name=@fn and Surname=@sn AND Global_User_ID=@gu and System_Function_ID = 123);
if @@ROWCOUNT =0
BEGIN Insert into System_User_Function (System_User_ID,System_Function_ID, Right_Type_ID, Store_ID) 
VALUES ((Select top(1) System_User_ID from [System_User] Where first_name=@fn and Surname=@sn AND Global_User_ID=@gu),123,4,1) 
END

Select * from System_User_Function Where system_user_id in (select system_user_id from [system_user] where first_name=@fn and Surname=@sn AND Global_User_ID=@gu and System_Function_ID = 124);
if @@ROWCOUNT =0
BEGIN Insert into System_User_Function (System_User_ID,System_Function_ID, Right_Type_ID, Store_ID) 
VALUES ((Select top(1) System_User_ID from [System_User] Where first_name=@fn and Surname=@sn AND Global_User_ID=@gu),124,4,1) 
END

Select * from System_User_Function Where system_user_id in (select system_user_id from [system_user] where first_name=@fn and Surname=@sn AND Global_User_ID=@gu and System_Function_ID = 125);
if @@ROWCOUNT =0
BEGIN Insert into System_User_Function (System_User_ID,System_Function_ID, Right_Type_ID, Store_ID) 
VALUES ((Select top(1) System_User_ID from [System_User] Where first_name=@fn and Surname=@sn AND Global_User_ID=@gu),125,5,1) 
END

Select * from System_User_Function Where system_user_id in (select system_user_id from [system_user] where first_name=@fn and Surname=@sn AND Global_User_ID=@gu and System_Function_ID = 127);
if @@ROWCOUNT =0
BEGIN Insert into System_User_Function (System_User_ID,System_Function_ID, Right_Type_ID, Store_ID) 
VALUES ((Select top(1) System_User_ID from [System_User] Where first_name=@fn and Surname=@sn AND Global_User_ID=@gu),127,5,1) 
END

Select * from System_User_Function Where system_user_id in (select system_user_id from [system_user] where first_name=@fn and Surname=@sn AND Global_User_ID=@gu and System_Function_ID = 128);
if @@ROWCOUNT =0
BEGIN Insert into System_User_Function (System_User_ID,System_Function_ID, Right_Type_ID, Store_ID) 
VALUES ((Select top(1) System_User_ID from [System_User] Where first_name=@fn and Surname=@sn AND Global_User_ID=@gu),128,5,1) 
END

Select * from System_User_Function Where system_user_id in (select system_user_id from [system_user] where first_name=@fn and Surname=@sn AND Global_User_ID=@gu and System_Function_ID = 129);
if @@ROWCOUNT =0
BEGIN Insert into System_User_Function (System_User_ID,System_Function_ID, Right_Type_ID, Store_ID) 
VALUES ((Select top(1) System_User_ID from [System_User] Where first_name=@fn and Surname=@sn AND Global_User_ID=@gu),129,4,1) 
END

Select * from System_User_Function Where system_user_id in (select system_user_id from [system_user] where first_name=@fn and Surname=@sn AND Global_User_ID=@gu and System_Function_ID = 130);
if @@ROWCOUNT =0
BEGIN Insert into System_User_Function (System_User_ID,System_Function_ID, Right_Type_ID, Store_ID) 
VALUES ((Select top(1) System_User_ID from [System_User] Where first_name=@fn and Surname=@sn AND Global_User_ID=@gu),130,4,1) 
END

Select * from System_User_Function Where system_user_id in (select system_user_id from [system_user] where first_name=@fn and Surname=@sn AND Global_User_ID=@gu and System_Function_ID = 131);
if @@ROWCOUNT =0
BEGIN Insert into System_User_Function (System_User_ID,System_Function_ID, Right_Type_ID, Store_ID) 
VALUES ((Select top(1) System_User_ID from [System_User] Where first_name=@fn and Surname=@sn AND Global_User_ID=@gu),131,5,1) 
END

Select * from System_User_Function Where system_user_id in (select system_user_id from [system_user] where first_name=@fn and Surname=@sn AND Global_User_ID=@gu and System_Function_ID = 132);
if @@ROWCOUNT =0
BEGIN Insert into System_User_Function (System_User_ID,System_Function_ID, Right_Type_ID, Store_ID) 
VALUES ((Select top(1) System_User_ID from [System_User] Where first_name=@fn and Surname=@sn AND Global_User_ID=@gu),132,5,1) 
END

Select * from System_User_Function Where system_user_id in (select system_user_id from [system_user] where first_name=@fn and Surname=@sn AND Global_User_ID=@gu and System_Function_ID = 134);
if @@ROWCOUNT =0
BEGIN Insert into System_User_Function (System_User_ID,System_Function_ID, Right_Type_ID, Store_ID) 
VALUES ((Select top(1) System_User_ID from [System_User] Where first_name=@fn and Surname=@sn AND Global_User_ID=@gu),134,5,1) 
END

Select * from System_User_Function Where system_user_id in (select system_user_id from [system_user] where first_name=@fn and Surname=@sn AND Global_User_ID=@gu and System_Function_ID = 135);
if @@ROWCOUNT =0
BEGIN Insert into System_User_Function (System_User_ID,System_Function_ID, Right_Type_ID, Store_ID) 
VALUES ((Select top(1) System_User_ID from [System_User] Where first_name=@fn and Surname=@sn AND Global_User_ID=@gu),135,5,1) 
END

Select * from System_User_Function Where system_user_id in (select system_user_id from [system_user] where first_name=@fn and Surname=@sn AND Global_User_ID=@gu and System_Function_ID = 136);
if @@ROWCOUNT =0
BEGIN Insert into System_User_Function (System_User_ID,System_Function_ID, Right_Type_ID, Store_ID) 
VALUES ((Select top(1) System_User_ID from [System_User] Where first_name=@fn and Surname=@sn AND Global_User_ID=@gu),136,5,1) 
END

Select * from System_User_Function Where system_user_id in (select system_user_id from [system_user] where first_name=@fn and Surname=@sn AND Global_User_ID=@gu and System_Function_ID = 137);
if @@ROWCOUNT =0
BEGIN Insert into System_User_Function (System_User_ID,System_Function_ID, Right_Type_ID, Store_ID) 
VALUES ((Select top(1) System_User_ID from [System_User] Where first_name=@fn and Surname=@sn AND Global_User_ID=@gu),137,5,1) 
END

Select * from System_User_Function Where system_user_id in (select system_user_id from [system_user] where first_name=@fn and Surname=@sn AND Global_User_ID=@gu and System_Function_ID = 138);
if @@ROWCOUNT =0
BEGIN Insert into System_User_Function (System_User_ID,System_Function_ID, Right_Type_ID, Store_ID) 
VALUES ((Select top(1) System_User_ID from [System_User] Where first_name=@fn and Surname=@sn AND Global_User_ID=@gu),138,5,1) 
END

Select * from System_User_Function Where system_user_id in (select system_user_id from [system_user] where first_name=@fn and Surname=@sn AND Global_User_ID=@gu and System_Function_ID = 139);
if @@ROWCOUNT =0
BEGIN Insert into System_User_Function (System_User_ID,System_Function_ID, Right_Type_ID, Store_ID) 
VALUES ((Select top(1) System_User_ID from [System_User] Where first_name=@fn and Surname=@sn AND Global_User_ID=@gu),139,5,1) 
END

Select * from System_User_Function Where system_user_id in (select system_user_id from [system_user] where first_name=@fn and Surname=@sn AND Global_User_ID=@gu and System_Function_ID = 140);
if @@ROWCOUNT =0
BEGIN Insert into System_User_Function (System_User_ID,System_Function_ID, Right_Type_ID, Store_ID) 
VALUES ((Select top(1) System_User_ID from [System_User] Where first_name=@fn and Surname=@sn AND Global_User_ID=@gu),140,5,1) 
END