USP_DATALIST_SALESORDERALERTEMAILADDRESSLOOKUP

create procedure dbo.USP_DATALIST_SALESORDERALERTEMAILADDRESSLOOKUP (
    @EMAILADDRESS dbo.UDT_EMAILADDRESS = null
)
as
    set @EMAILADDRESS = isnull(@EMAILADDRESS, '')

    select
        SALESORDERALERTEMAILADDRESS.ID,
        SALESORDERALERTEMAILADDRESS.EMAILADDRESS,
        SALESORDERALERTEMAILADDRESS.APPUSERID,
        APPUSER.DISPLAYNAME as APPUSERDISPLAYNAME
    from dbo.SALESORDERALERTEMAILADDRESS
    inner join dbo.APPUSER on
        SALESORDERALERTEMAILADDRESS.APPUSERID = APPUSER.ID
    where len(@EMAILADDRESS) = 0 or SALESORDERALERTEMAILADDRESS.EMAILADDRESS = @EMAILADDRESS