TR_ITINERARYSTAFFRESOURCE_UPDATE_JOBOCCURRENCE
Definition
Copy
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