USP_APPUSER_GETAPPUSERINFO_FROM_EMAILADDRESS

CREATE procedure dbo.USP_APPUSER_GETAPPUSERINFO_FROM_EMAILADDRESS(
    @EMAILADDRESS nvarchar(100)
)
as
begin

    select
        ID,
        ISSYSADMIN,
        DISPLAYNAME,
        USERNAME,
        cast(
            case
                when exists(select 1 from dbo.APPUSERCLAIMS where APPUSERID = APPUSER.ID) then 1
                else 0
            end
            as bit
        ) as APPUSERCLAIMEXISTS,
        HASRUNASRIGHTS
    from dbo.APPUSER
    where UPPER(EMAILADDRESS) = UPPER(@EMAILADDRESS);

    return 0;
end;