USP_SIMPLEDATALIST_EMAILCURRENT

CREATE procedure dbo.USP_SIMPLEDATALIST_EMAILCURRENT
(
@CONSTITUENTID uniqueidentifier = null
)
as
    select 
        EMAILADDRESS.ID as VALUE,
        (coalesce(EMAILADDRESSTYPECODE.DESCRIPTION + '-', '') + (case when EMAILADDRESS.ISPRIMARY=1 then 'primary-' else '' end) +
        case when EMAILADDRESS.EMAILADDRESS = N'' then '<No email address>' else coalesce(left(EMAILADDRESS.EMAILADDRESS, charindex(nchar(10), EMAILADDRESS.EMAILADDRESS + nchar(10)) -1), '<No email address>') end 
        ) as LABEL        
    from dbo.EMAILADDRESS
    left outer join dbo.EMAILADDRESSTYPECODE on EMAILADDRESSTYPECODE.ID = EMAILADDRESS.EMAILADDRESSTYPECODEID
    where EMAILADDRESS.CONSTITUENTID = @CONSTITUENTID 
    and EMAILADDRESS.ENDDATE is null
    order by EMAILADDRESS.ISPRIMARY desc, EMAILADDRESSTYPECODE.DESCRIPTION,EMAILADDRESS.EMAILADDRESS