TR_ITINERARYRESOURCE_DELETE_REQUIREDRESOURCECANNOTBEDELETED (Trigger)

                
                    CREATE trigger [dbo].[TR_ITINERARYRESOURCE_DELETE_REQUIREDRESOURCECANNOTBEDELETED] 
                        on [dbo].[ITINERARYRESOURCE] 
                        after delete not for replication
                        as begin
                        
                            if (
                                exists 
                                (
                                    select DELETEDITINERARYRESOURCE.ID
                                    from deleted as DELETEDITINERARYRESOURCE
                                    inner join dbo.ITINERARY on DELETEDITINERARYRESOURCE.ITINERARYID = ITINERARY.ID
                                    inner join dbo.GROUPTYPEREQUIREDRESOURCE on 
                                        (GROUPTYPEREQUIREDRESOURCE.GROUPSALESGROUPTYPECODEID = ITINERARY.GROUPSALESGROUPTYPECODEID) and
                                        (DELETEDITINERARYRESOURCE.RESOURCEID = GROUPTYPEREQUIREDRESOURCE.RESOURCEID)
                                    where DELETEDITINERARYRESOURCE.IGNORESQUANTITYFORCAPACITY = 0
                                )
                            )
                            begin
                                rollback transaction;
                                raiserror('BBERR_CANNOTDELETEREQUIREDRESOURCE', 13, 1);
                            end
                        
                        end