USE [DEV]

GO

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TRIGGER [dbo].[update_trigger]ON [dbo].[Transaction_Tracking]

AFTER UPDATE

AS

BEGIN

INSERT

INTO [dbo].[eRPT_Transaction_Audit]

( Package_ID, Received_Date, Start_Date,Operation, TriggerTable)

SELECT i.Package_ID, i.Received_Date, i.Start_Date,'U', 'I'

FROM inserted i

INNER JOIN deleted d ON i.Track_ID=d.Track_ID

WHERE (SUBSTRING(i.Package_ID,1,3) = 'RVW' or SUBSTRING(d.Package_ID,1,3) = 'RVW')

and i.Start_Date<>d.Start_Date

;

END

;

GO