--Estudiantes: Proyecto 1
Insert into ASDK_SERVICE_USER
Select Asdk_service.FL_INT_SERVICE_ID, Usuarios.Codusuario
From Asdk_service Cross join Usuarios
     left outer join ASDK_SERVICE_USER on Usuarios.Codusuario = ASDK_SERVICE_USER.seus_user_id 
     and Asdk_service.Fl_int_service_id = ASDK_SERVICE_USER.seus_service_id
	 
Where ASDK_SERVICE_USER.seus_user_id is null
AND ASDK_SERVICE.fl_int_project_id = 1
AND USUARIOS.USERNAME NOT LIKE '%@%';

-- Administradores: Proyecto 2
Insert into ASDK_SERVICE_USER
Select Asdk_service.FL_INT_SERVICE_ID, Usuarios.Codusuario
From Asdk_service Cross join Usuarios
     left outer join ASDK_SERVICE_USER on Usuarios.Codusuario = ASDK_SERVICE_USER.seus_user_id 
     and Asdk_service.Fl_int_service_id = ASDK_SERVICE_USER.seus_service_id
	 
Where ASDK_SERVICE_USER.seus_user_id is null
AND ASDK_SERVICE.fl_int_project_id = 2
AND USUARIOS.USERNAME LIKE '%@%';