USP_DATALIST_CONSTITUENTPROFILEDASHBOARDADDRESS

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

                        if @ISVISIBLE = 1
                        begin
                            select
                                coalesce(atc.DESCRIPTION, '') ADDRESSTYPE,
                                case when a.ISPRIMARY = 1 then 'Yes' else 'No' end as ISPRIMARY,
                                case when a.DONOTMAIL = 1 then 'No' else 'Yes' end as SENDMAIL,
                                a.STARTDATE,
                                a.ENDDATE,
                                dbo.UFN_BUILDFULLADDRESS(a.ID, a.ADDRESSBLOCK, a.CITY, a.STATEID, a.POSTCODE, a.COUNTRYID) ADDRESS,
                                a.HISTORICALSTARTDATE,
                                a.HISTORICALENDDATE
                            from
                                dbo.ADDRESS a
                                left outer join dbo.ADDRESSTYPECODE atc
                                on a.ADDRESSTYPECODEID = atc.ID
                            where
                                a.CONSTITUENTID = @CONSTITUENTID;                                
                        end