USP_BBNCUSERMAP_EDITLOAD

create procedure dbo.[USP_BBNCUSERMAP_EDITLOAD]
(
  @ID uniqueidentifier
)
as
    set nocount on;

    select
        [BBNCUSERMAP].[BBNCUSERNAME],
        isnull([APPUSER].[USERNAME], [APPUSER].[DISPLAYNAME]) as [APPUSERNAME],
        [BBNCUSERMAP].[TSLONG]
    from dbo.[BBNCUSERMAP]
  inner join dbo.[APPUSER] on [BBNCUSERMAP].[ID] = [APPUSER].[ID]
    where [BBNCUSERMAP].[ID] = @ID;

    return 0;