Ребят, подскажите как сделать триггер?

SET NOCOUNT ON;
DELETE FROM WORKFLOW WHERE PID=3426 AND SID=85;
DELETE FROM WORKFLOW WHERE PID=2916 AND SID=77;

IF SELECT 0 FROM HISTORY WHERE PID=3426 AND SID=85 AND Country='Poland' THEN 
    OK
ELSE
    INSERT INTO HISTORY (PID, SID, Country, DateOfInsertRecord) VALUES (3426, 85, 'Poland', GetDate())
END;

SET NOCOUNT ON;
UPDATE WORKFLOW SET Country='Pakistan' WHERE PID=3426 AND SID=85;
UPDATE WORKFLOW SET Date=GetDate() WHERE PID=2916 AND SID=77;

IF SELECT 0 FROM HISTORY WHERE PID=3426 AND SID=85 AND Country='Poland' THEN 
    OK
ELSE
    INSERT INTO HISTORY (PID, SID, Country, DateOfInsertRecord) VALUES (3426, 85, 'Poland', GetDate())
END;

IF OBJECT_ID(N'[dbo].[Workflow_FOR_HISTORY]','TR') IS NULL
EXECUTE(N'CREATE TRIGGER [dbo].[Workflow_FOR_HISTORY] ON [dbo].[Workflow] FOR DELETE,UPDATE AS RETURN');
GO
ALTER TRIGGER [dbo].[Workflow_FOR_HISTORY] ON [dbo].[Workflow] FOR DELETE,UPDATE AS
IF EXISTS(SELECT * FROM deleted)
BEGIN
 INSERT [dbo].[WorkflowHistory](PID,SID,Country,[Date],[User],[DateOfChange],[Action])
 SELECT d.PID,d.SID,d.Country,d.[Date],ORIGINAL_LOGIN(),CURRENT_TIMESTAMP,CASE WHEN i.PID IS NULL THEN 'DELETE' ELSE 'UPDATE' END
 FROM deleted d
 LEFT JOIN inserted i ON d.PID=i.P AND d.SID=i.SID
 WHERE i.PID IS NULL
    OR NOT EXISTS
    (
     SELECT LTRIM(RTRIM(d.Country COLLATE Cyrillic_General_CI_AI))
     INTERSECT
     SELECT LTRIM(RTRIM(i.Country COLLATE Cyrillic_General_CI_AI))
    );
END;

SELECT TOP 1 @COUNTRY FROM HISTORY WHERE PID=d.PID AND SID=d.SID ORDER BY DateOfChange DESC
IF @COUNTRY <> d.COUNTRY THEN 
    INSERT 
ELSE
    SKIP
END;

ALTER TRIGGER [dbo].[Workflow_FOR_HISTORY] ON [dbo].[Workflow]
   AFTER DELETE,UPDATE
AS 
BEGIN
 
SET NOCOUNT ON;
 
IF EXISTS(SELECT * FROM deleted) BEGIN
 
  INSERT INTO HISTORY
  SELECT d.PID, d.SID, RTRIM(LTRIM(d.Country)), GetDate()
  FROM
    deleted d
    LEFT JOIN inserted i ON i.PID = d.PID AND i.SID = d.SID 
    LEFT JOIN (
      SELECT h.PID, h.SID, h.Country
      FROM (
        SELECT PID, SID, MAX(DateOfInsertRecord) Maxdate 
        FROM HISTORY 
        GROUP BY PID, SID
      ) l
        JOIN HISTORY h ON l.PID = h.PID AND l.SID = h.SID AND h.DateOfInsertRecord = l.MaxDate
    ) lc ON lc.PID = d.PID AND lc.SID = d.SID
  WHERE
    d.Country IS NOT NULL AND LTRIM(d.Country) <> '' AND (
      i.PID IS NULL -- удаление
      OR
      RTRIM(LTRIM(d.Country)) <> RTRIM(LTRIM(ISNULL(i.Country, ''))) -- корректировка Country
    ) AND (
      lc.Country IS NULL
      OR
      lc.Country <> RTRIM(LTRIM(d.Country)) 
    )
END

create trigger trWorkflow_UpdateHistory
on Workflow
after update, delete
as
begin
 set nocount on;
 
 if not exists(select 1 from deleted)
  return;
 
 if exists(select 1 from inserted) and not update(Country)
  return;
 
 with s as
 (
  select
   d.PID, d.SID, ltrim(rtrim(d.Country)) as Country
  from
   deleted d left join
   inserted i on i.PID = d.PID and s.SID = d.SID
  where
   nullif(d.Country, '') is not null and
   not exists(select ltrim(rtrim(d.Country)) collate Cyrillic_General_CI_AI intersect select ltrim(rtrim(i.Country)) collate Cyrillic_General_CI_AI)
 ),
 t as
 (
  select top (1) PID, SID, Country, DateOfInsertRecord from History order by DateOfInsertRecord desc
 )
 merge into t
 using s on s.PID = t.PID and s.SID = t.SID and s.Country = t.Country
 when not matched then
  insert (PID, SID, Country, DateOfInsertRecord) values (s.PID, s.SID, s.Country, getdate());
end;