USP_DATALIST_BBNCUSERMAP

Lists application users that are mapped to website users.

Definition



CREATE procedure dbo.[USP_DATALIST_BBNCUSERMAP]
as
  set nocount on;

  select
    [APPUSER].[ID] as [APPUSERID],
    case when len([APPUSER].[CUSTOM_AUTHENTICATION_USERID]) = 0 then 
      isnull([APPUSER].[USERNAME], [APPUSER].[DISPLAYNAME])
    else 
      [APPUSER].[CUSTOM_AUTHENTICATION_USERID] end as [APPUSERNAME],
    [BBNCUSERMAP].[BBNCUSERNAME]
  from dbo.[APPUSER]
  inner join dbo.[BBNCUSERMAP] on [BBNCUSERMAP].[ID] = [APPUSER].[ID]
  order by isnull([APPUSER].[USERNAME], [APPUSER].[DISPLAYNAME]);