TR_REVENUELIFECYCLE_UPDATE (Trigger)

                
                    CREATE trigger [dbo].[TR_REVENUELIFECYCLE_UPDATE] on [dbo].[REVENUELIFECYCLE] after update not for replication as
                    begin
                        set nocount on
                        
                        if update(LIFECYCLETYPEID) or update(DONORSTATECODE) begin
                            insert into dbo.REVENUELIFECYCLEHISTORY 
                                (CONSTITUENTID, LIFECYCLETYPEID, DONORSTATECODE, STARTDATE, ENDDATE, ADDEDBYID, CHANGEDBYID)
                                (select 
                                    CONSTITUENTID, 
                                    LIFECYCLETYPEID, 
                                    DONORSTATECODE, 
                                    STARTDATE, 
                                    getdate(),
                                    CHANGEDBYID, 
                                    CHANGEDBYID
                                from 
                                    DELETED 
                                where 
                                    DELETED.ID not in (select ID from INSERTED where INSERTED.CONSTITUENTID = DELETED.CONSTITUENTID and INSERTED.LIFECYCLETYPEID = DELETED.LIFECYCLETYPEID and INSERTED.DONORSTATECODE = DELETED.DONORSTATECODE)
                                )                                    
                        end
                    end