USP_CONSTITUENTSOURCEANALYSIS_UPDATEDONOR

            create procedure dbo.USP_CONSTITUENTSOURCEANALYSIS_UPDATEDONOR
            (
                @CHANGEAGENTID uniqueidentifier = null,
                @CHANGEDATE datetime = null
            )
            as
            set nocount on;

            begin try
                if @CHANGEAGENTID is null
                    exec dbo.USP_CHANGEAGENT_GETORCREATECHANGEAGENT @CHANGEAGENTID output;
                if @CHANGEDATE is null
                    set @CHANGEDATE = getdate();

                --reset the NEEDSUPDATE flag from previous runs

                update dbo.CONSTITUENTSOURCEANALYSISCACHEDONOR
                    set NEEDSUPDATE = 0,
                        CHANGEDBYID = @CHANGEAGENTID,
                        DATECHANGED = @CHANGEDATE
                where NEEDSUPDATE = 1;    

                --any records that have changed since last time needs to have their DATETO date set. Also set NEEDSUPDATE so the 

                --insert statement will know to write the updated data to the cache

                with [CONSTIT_INFO] as
                (
                    select
                        CONSTITUENT.ID as [CONSTITUENTID],
                        dbo.UFN_CONSTITUENT_ISDONOR(CONSTITUENT.ID) as [ISDONOR]
                    from dbo.CONSTITUENT
                    inner join dbo.CONSTITUENTSOURCEANALYSISCACHEDONOR on CONSTITUENTSOURCEANALYSISCACHEDONOR.CONSTITUENTID = CONSTITUENT.ID
                    where (@CHANGEDATE > CONSTITUENTSOURCEANALYSISCACHEDONOR.DATEFROM)
                ) 
                update CONSTITUENTSOURCEANALYSISCACHEDONOR
                        set CONSTITUENTSOURCEANALYSISCACHEDONOR.NEEDSUPDATE = 1,
                            CONSTITUENTSOURCEANALYSISCACHEDONOR.DATETO = @CHANGEDATE,
                            CONSTITUENTSOURCEANALYSISCACHEDONOR.CHANGEDBYID = @CHANGEAGENTID,
                            CONSTITUENTSOURCEANALYSISCACHEDONOR.DATECHANGED = @CHANGEDATE
                    from CONSTITUENTSOURCEANALYSISCACHEDONOR
                    inner join [CONSTIT_INFO] on [CONSTIT_INFO].CONSTITUENTID = CONSTITUENTSOURCEANALYSISCACHEDONOR.CONSTITUENTID and CONSTITUENTSOURCEANALYSISCACHEDONOR.DATETO is null
                    where
                        [CONSTIT_INFO].ISDONOR <> CONSTITUENTSOURCEANALYSISCACHEDONOR.VALUE;


                --For any constituents that either don't have a record in the cache table OR have a NEEDSUPDATE flag set, insert their

                --current address data into the cache

                with [CONSTIT_INFO] as 
                (
                    select
                        CONSTITUENT.ID as [CONSTITUENTID],
                        dbo.UFN_CONSTITUENT_ISDONOR(CONSTITUENT.ID) as [ISDONOR]
                    from dbo.CONSTITUENT
                    left join dbo.CONSTITUENTSOURCEANALYSISCACHEDONOR on CONSTITUENTSOURCEANALYSISCACHEDONOR.CONSTITUENTID = CONSTITUENT.ID
                    where CONSTITUENTSOURCEANALYSISCACHEDONOR.ID is null or CONSTITUENTSOURCEANALYSISCACHEDONOR.NEEDSUPDATE = 1
                )
                insert into dbo.CONSTITUENTSOURCEANALYSISCACHEDONOR(ID, NEEDSUPDATE, CONSTITUENTID, DATEFROM, DATETO, VALUE,
                                                                ADDEDBYID, CHANGEDBYID, DATEADDED, DATECHANGED)
                    select
                        newid(),
                        0,
                        [CONSTIT_INFO].CONSTITUENTID,
                        @CHANGEDATE,
                        null,
                        [CONSTIT_INFO].ISDONOR,

                        @CHANGEAGENTID,
                        @CHANGEAGENTID,
                        @CHANGEDATE,
                        @CHANGEDATE
                    from [CONSTIT_INFO];

                --No need to reset the NEEDSUPDATE flag since that will be handled the next time this procedure is run

            end try
            begin catch
                exec dbo.USP_RAISE_ERROR;
                return 1;
            end catch

            return 0;