USP_SIMPLEDATALIST_APPUSER

Returns the set of application users defined in the system

Definition

Copy


CREATE procedure dbo.USP_SIMPLEDATALIST_APPUSER
as begin
    select ID as VALUE, case when DISPLAYNAME = '' then USERNAME else DISPLAYNAME end as LABEL 
    from dbo.APPUSER
    order by LABEL
end