TR_PROSPECTPLAN_T2BUPDATE (Trigger)

                
    CREATE trigger TR_PROSPECTPLAN_T2BUPDATE on dbo.PROSPECTPLAN after update not for replication
    as begin
      -- intentionally leaving off UFN_B2T_CONTEXTISSYNC condition, even updates from sync need to trigger update

        -- force re-sync of any opportunities

        update dbo.B2TROWS
        set FORCEUPDATE = 1
        where BBECID in(select o.ID
                        from dbo.OPPORTUNITY o, INSERTED i
                        where o.PROSPECTPLANID = i.ID)
        and BBECTABLE = 'OPPORTUNITY'
        and TATABLE = 'BBEC_OPPORTUNITY'
    end