USP_DATALIST_CLIENTUSERSEXTENSION

CREATE procedure dbo.USP_DATALIST_CLIENTUSERSEXTENSION(
  @CLIENTUSERID int = null,
  @IDENTIFIER varchar(512) = null
)
as
    set nocount on;

    select 
        CLIENTUSERSEXTENSION.[ID],
        CLIENTUSERSEXTENSION.[CLIENTUSERID],
        CLIENTUSERSEXTENSION.[PROVIDERNAME],
        CLIENTUSERSEXTENSION.[IDENTIFIER],
        CLIENTUSERSEXTENSION.[DISPLAYNAME],
        CLIENTUSERSEXTENSION.[PREFERREDUSERNAME],
        CLIENTUSERSEXTENSION.[GIVENNAME],
        CLIENTUSERSEXTENSION.[FAMILYNAME],
        CLIENTUSERSEXTENSION.[FORMATTEDNAME]
    from 
        dbo.CLIENTUSERSEXTENSION
        JOIN ClientUsers AS CU ON CU.ID = CLIENTUSERSEXTENSION.CLIENTUSERID
        AND CU.Deleted = 0        
    where 
    (@CLIENTUSERID is null or CLIENTUSERID = @CLIENTUSERID) 
    and (@IDENTIFIER is null or IDENTIFIER = @IDENTIFIER)