ALTER TRIGGER [dbo].[AuditInsertUpdateTaskStepMaterialResult]
   ON  [dbo].[TaskStepMaterialResult]
   AFTER INSERT,UPDATE
AS
BEGIN
    SET NOCOUNT ON;

    DECLARE @Action as char(1)
    DECLARE @Count as int
    SET @Action = 'I' -- Set Action to 'I'nsert by default.
    SELECT @Count = COUNT(*) FROM DELETED
    if @Count > 0
    BEGIN
        SELECT @Count = COUNT(*) FROM INSERTED
        IF @Count > 0
            SET @Action = 'U' -- Set Action to 'U'pdated.
    END


    Insert Audit_TaskStepMaterialResult(
    [ObjectId]
   ,[Action]
   ,[HostName]
   ,[AppName]
   ,[DBUser]
   ,[AppUserId]
   ,TaskResultId
   ,TaskStepId
   ,[StepQty]
   ,[OccurrenceNumber]
   ,StatusId
    )
    select
    Inserted.TaskStepResultId,
    CASE WHEN exists(select * from deleted) THEN 'Update' ELSE 'Insert' END,
    Host_Name(),
    App_Name(),
    SYSTEM_USER,
    Inserted.AppUserId,
    Inserted.TaskResultId,
    Inserted.TaskStepId,
    Inserted.StepQty,
    Inserted.OccurrenceNumber,
    Inserted.StatusId
    from Inserted

    update TaskStepMaterialResult set AppUserId = null
      where TaskStepResultId in (select TaskStepResultId from Inserted)

    if @Action = 'U'
        update TaskStepMaterialResult set HasChanges = HasChanges+1
            where TaskStepResultId in (select TaskStepResultId from Inserted)

END