TR_ITINERARYITEMSTAFFRESOURCE_UPDATE_JOBOCCURRENCE (Trigger)

                
                    CREATE trigger [dbo].[TR_ITINERARYITEMSTAFFRESOURCE_UPDATE_JOBOCCURRENCE] 
                        on [dbo].[ITINERARYITEMSTAFFRESOURCE] 
                        after update not for replication
                    as begin
                        declare @CURRENTDATE datetime;
                        set @CURRENTDATE = GetDate();
                        
                        update dbo.JOBOCCURRENCE
                            set JOBOCCURRENCE.VOLUNTEERSNEEDED = NEWITINERARYITEMSTAFFRESOURCE.QUANTITYNEEDED,
                                JOBOCCURRENCE.CHANGEDBYID = NEWITINERARYITEMSTAFFRESOURCE.CHANGEDBYID,
                                JOBOCCURRENCE.DATECHANGED = @CURRENTDATE
                        from dbo.JOBOCCURRENCE
                            inner join inserted as NEWITINERARYITEMSTAFFRESOURCE
                                on NEWITINERARYITEMSTAFFRESOURCE.JOBOCCURRENCEID = JOBOCCURRENCE.ID
                            inner join deleted as OLDITINERARYITEMSTAFFRESOURCE 
                                on NEWITINERARYITEMSTAFFRESOURCE.JOBOCCURRENCEID = OLDITINERARYITEMSTAFFRESOURCE.JOBOCCURRENCEID
                        where OLDITINERARYITEMSTAFFRESOURCE.QUANTITYNEEDED <> NEWITINERARYITEMSTAFFRESOURCE.QUANTITYNEEDED
                    end