ALTER TRIGGER [dbo].[Tg_Update_Service]

ON [dbo].[Table_name]

AFTER UPDATE

AS

BEGIN

-- SET NOCOUNT ON added to prevent extra result sets from

-- interfering with SELECT statements.

SET NOCOUNT ON;

DECLARE @ServiceLogID NVARCHAR(50)

DECLARE @ServiceID NVARCHAR(30)

DECLARE @Name NVARCHAR(100)

DECLARE @Deleted BIT

DECLARE @LocationID NVARCHAR(30)

DECLARE @ModifiedDt DATETIME

DECLARE @ModifiedBy VARCHAR(50)

SELECT@ServiceID = I.ServiceID, @Name = I.[Name],

@LocationID = I.LocationID, @ModifiedBy = I.CreatedBy,

@Deleted = I.Deleted

FROM INSERTED I

EXEC Procedure_Name,'Table_Name', @LocationID, @ServiceLogID OUT

SET @ModifiedDt = GETDATE()

IF (@DELETED = 0)

BEGIN

INSERT INTO Table_Name(ServiceLogID, ServiceID, [Name], Deleted,

LocationID, ModifiedDt, ModifiedBy)

VALUES (@ServiceLogID, @ServiceID, @Name, @Deleted, @LocationID,

@ModifiedDt, @ModifiedBy)

END

ELSE

BEGIN

SET @ModifiedBy = @ModifiedBy + '/Deleted'

INSERT INTO Table_Name(ServiceLogID, ServiceID, [Name], Deleted,

LocationID, ModifiedDt, ModifiedBy)

VALUES (@ServiceLogID, @ServiceID, @Name, @Deleted, @LocationID,

@ModifiedDt, @ModifiedBy)

END

END