USP_APPUSER_GETAPPUSERINFO_FROM_USERSID

CREATE procedure dbo.USP_APPUSER_GETAPPUSERINFO_FROM_USERSID(@USERSID varbinary(85))
as
begin

    select
        APPUSER.ID,
        APPUSER.ISSYSADMIN,
        APPUSER.DISPLAYNAME,
        APPUSER.USERNAME,
        cast(
            case
                when exists(select 1 from dbo.APPUSERCLAIMS where APPUSERCLAIMS.APPUSERID = APPUSER.ID) then 1
                else 0
            end
            as bit
        ) as APPUSERCLAIMEXISTS,
        APPUSER.EMAILADDRESS,
        isnull(APPUSERTHIRDPARTYAUTH.INACTIVE, 0) as INACTIVE,
        isnull(APPUSER.ISACTIVE, 1) as ISACTIVE,
        APPUSER.HASRUNASRIGHTS
    from dbo.APPUSER
    left outer join dbo.APPUSERTHIRDPARTYAUTH
        on APPUSER.ID = APPUSERTHIRDPARTYAUTH.ID
    where APPUSER.USERSID = @USERSID; 

    return 0;

end;