TR_ITINERARYSTAFFRESOURCE_UPDATE_JOBOCCURRENCE (Trigger)

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