>IF you didn't change cs_enddate from anywhere else but from DELETE trigger you could do this in UPDATE Trigger: >
>IFEXISTS(SELECT1FROM INSERTED INNERJOIN DELETED ON Inserted.cs_enddate <> Deleted.cs_enddate)
> BEGIN
> --- cs_enddate is updated that means the trigger is fired from DELETE triger
> RETURN
> END
>.....
>
> >But as I said, that is VALID only if you didn't change cs_enddate anywhere else but DELETE trigger.