TR_MEMBERSHIP_UPDATE_CANCELLATIONREASONCODEID

                    create trigger TR_MEMBERSHIP_UPDATE_CANCELLATIONREASONCODEID on dbo.MEMBERSHIP after update not for replication
                    as begin

                        if update(STATUSCODE)
                        begin
                            update dbo.MEMBERSHIP set
                                CANCELLATIONREASONCODEID = null
                            from INSERTED
                            where
                                INSERTED.ID = MEMBERSHIP.ID and
                                INSERTED.STATUSCODE <> 1
                        end

                    end