TR_ITINERARYSTAFFRESOURCE_DELETE_JOBOCCURRENCE

                    CREATE trigger [dbo].[TR_ITINERARYSTAFFRESOURCE_DELETE_JOBOCCURRENCE] 
                        on [dbo].[ITINERARYSTAFFRESOURCE] 
                        after delete not for replication
                    as begin
                        delete from dbo.JOBOCCURRENCE
                        from deleted
                        where deleted.JOBOCCURRENCEID = JOBOCCURRENCE.ID
                    end