USP_SALESORDER_RECIPIENTPHONE_SIMPLEDATALIST

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

                    select 
                        PHONE.ID VALUE,
                        coalesce('(' + PHONETYPECODE.DESCRIPTION + ') ' ,'') + PHONE.NUMBER LABEL
                    from PHONE
                        left join PHONETYPECODE on PHONETYPECODE.ID = PHONE.PHONETYPECODEID
                    where PHONE.CONSTITUENTID = @CONSTITUENTID
          order by PHONE.ISPRIMARY DESC