USP_DATALIST_CONSTITUENTPROFILEDASHBOARDEMAILS

                    CREATE procedure dbo.USP_DATALIST_CONSTITUENTPROFILEDASHBOARDEMAILS
                    (
                        @CONSTITUENTID uniqueidentifier,
                        @ISVISIBLE bit = 1
                    )
                    as
                        set nocount on;

                        if @ISVISIBLE = 1
                        begin

                            select
                                EMAILADDRESS.EMAILADDRESS,
                                dbo.UFN_EMAILADDRESSTYPECODE_GETDESCRIPTION(EMAILADDRESS.EMAILADDRESSTYPECODEID) as TYPE,
                                case when EMAILADDRESS.ISPRIMARY = 1 then 'Yes' else 'No' end ISPRIMARY,
                                EMAILADDRESS.DONOTEMAIL,
                EMAILADDRESS.STARTDATE,
                                EMAILADDRESS.ENDDATE
                            from
                                dbo.EMAILADDRESS
                            where
                                EMAILADDRESS.CONSTITUENTID = @CONSTITUENTID
                            order by
                                EMAILADDRESS.ISPRIMARY desc, TYPE;
                        end