TR_ORGANIZATIONPARENTHISTORY_INSERTUPDATE_VALIDDATES (Trigger)

                
    CREATE trigger TR_ORGANIZATIONPARENTHISTORY_INSERTUPDATE_VALIDDATES on dbo.ORGANIZATIONPARENTHISTORY for update, insert
    as begin
        set nocount on
        
        if update(STARTDATE) or update(ENDDATE)
        begin
            if exists 
               (select i.ID
                from inserted i
                    inner join dbo.ORGANIZATIONPARENTHISTORY o
                        on (i.CHILDCORPID = o.CHILDCORPID
                            and i.ID <> o.ID)
                where (not ((o.STARTDATE is null and o.ENDDATE is null) or (i.STARTDATE is null and i.ENDDATE is null)))
                    and (o.STARTDATE is null or i.ENDDATE is null or o.STARTDATE <= i.ENDDATE)
                    and (i.STARTDATE is null or o.ENDDATE is null or i.STARTDATE <= o.ENDDATE)
               )
                raiserror('BBERR_ORGANIZATIONPARENTHISTORY_VALIDDATES', 13,1)
        end
    end