Project

General

Profile

Bug #2411 ยป CREATE TRIGGER AfterInsertPHRPA0019.txt

M Azid Wahyudi, 11/21/2023 03:54 PM

 
1
CREATE TRIGGER AfterInsertPHRPA0019CrossDay
2
ON PHRPA0019
3
AFTER INSERT
4
AS
5
BEGIN
6
    SET NOCOUNT ON;
7

    
8
    UPDATE p
9
    SET EndDate = i.StartDate
10
    FROM PHRPA0019 p
11
    INNER JOIN inserted i ON p.EmployeeID = i.EmployeeID 
12
    WHERE i.StartDate != p.EndDate
13
END;
14

    
    (1-1/1)