USP_SIMPLEDATALIST_APPUSERBUSINESSPROCESSOWNER

create procedure dbo.USP_SIMPLEDATALIST_APPUSERBUSINESSPROCESSOWNER
as
set nocount on;

select distinct
    APPUSER.ID as VALUE,
    case when APPUSER.DISPLAYNAME = '' then APPUSER.USERNAME else APPUSER.DISPLAYNAME end as LABEL
from
    dbo.BUSINESSPROCESSINSTANCE
    inner join dbo.APPUSER on APPUSER.ID = BUSINESSPROCESSINSTANCE.OWNERID
order by
    case when APPUSER.DISPLAYNAME = '' then APPUSER.USERNAME else APPUSER.DISPLAYNAME end;