USP_SALESORDER_RECIPIENTEMAILADDRESS_SIMPLEDATALIST

                CREATE procedure dbo.USP_SALESORDER_RECIPIENTEMAILADDRESS_SIMPLEDATALIST(
                    @CONSTITUENTID uniqueidentifier
                )
                as
                    set nocount on;

                    select 
                        e.ID VALUE,
                        coalesce('(' + etc.DESCRIPTION + ') ' ,'') + e.EMAILADDRESS LABEL
                    from EMAILADDRESS e
                        left join EMAILADDRESSTYPECODE etc on etc.ID=e.EMAILADDRESSTYPECODEID
                    where e.CONSTITUENTID=@CONSTITUENTID
          order by e.ISPRIMARY DESC