Filter by group name

-- Get roles by group name
declare @tRoles table(name nvarchar(50), roleID uniqueidentifier)
insert into @tRoles
select
    rl.LoweredRoleName
    ,rl.RoleId
from
    aspnet_Roles rl
where rl.LoweredRoleName in(select Value from dbo.split(@groupUsers, ','))

-- Get crm users by role
declare @tUserRoles table(userID int, roleName nvarchar(100))
insert into @tUserRoles
select
    us.id,
    rl.name
from
    as_users us
inner join aspnet_UsersInRoles usRole on usRole.UserId = us.userGuid
inner join @tRoles rl on rl.roleID = usRole.roleID
where
    crmID = @crmID