UFN_CLIENTUSER_GETBYID

Return

Return Type
nvarchar(200)

Parameters

Parameter	Parameter Type	Mode	Description
@BBNCUSERID	int	IN
@CONCATUSERNAME	bit	IN

Definition

Copy



      create function dbo.UFN_CLIENTUSER_GETBYID
      (
       @BBNCUSERID int,
       @CONCATUSERNAME bit = 0
      )
      returns nvarchar(200)
      with execute as caller
      as 
      begin
          declare    @CLIENTUSER nvarchar(200) = '';
          declare @USERNAME nvarchar(100) = '';

          if @BBNCUSERID > 0
              begin
                  select 
                      @CLIENTUSER = FirstName + ' ' + LastName,
                      @USERNAME = UserName
                  from 
                      dbo.ClientUsers 
                  where 
                      ID = @BBNCUSERID;

                  if @CONCATUSERNAME = 1
                      return @CLIENTUSER + ' <' + @USERNAME + '>';
              end

          return @CLIENTUSER;    
      end