CREATE procedure [dbo].[MssWebGetTaskUsers]
as
begin
set nocount on

    ;with usersWithDefaultLaborType as(
    select
        users.sysUserId,
        users.EmpNo,
        users.FullName,
        max(SysUserLaborTypeMap.LaborTypeFID) LaborTypeFID
    from udfGetAllFreeTaskUsers() users
    left outer join SysUserLaborTypeMap on SysUserLaborTypeMap.SysUserFID = users.SysuserID and
    SysUserLaborTypeMap.LaborTypeFID = users.LaborTypePriKey
    and SysUserLaborTypeMap.[Default] = 1
    group by users.sysUserId, users.EmpNo,users.FullName
    )
    select     
        usersWithDefaultLaborType.sysUserId,
        usersWithDefaultLaborType.EmpNo,
        usersWithDefaultLaborType.FullName,
        case when LaborType.LaborType = 'Coor' then 'Coordinator'
            when LaborType.LaborType = 'Disp' then 'Dispatch'
            when LaborType.LaborType = 'LD Disp' then 'LD Dispatch'
            else LaborType.LaborType
        end as DefaultLaborType
    from usersWithDefaultLaborType
    left join LaborType on LaborType.PriKey = usersWithDefaultLaborType.LaborTypeFID
    order by usersWithDefaultLaborType.FullName
end
GO
GRANT EXECUTE ON  [dbo].[MssWebGetTaskUsers] TO [MssExec]
GO