USP_SIMPLEDATALIST_CONSTITUENTPHONE

                create procedure USP_SIMPLEDATALIST_CONSTITUENTPHONE(
                    @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 and 
                        PHONE.DONOTCALL = 0