Project

General

Profile

Download (414 Bytes)

Bug #769 » [Time Management] - Create Query untuk Update Data Remain Quota di PHRPA0017 sesuai update data di PHRPA0018.txt

Saswanto Tampan, 01/19/2022 05:49 PM

 
1 
UPDATE PHRPA0017 set
2 
RemainQuota =CONVERT(INT, RemainQuota) - CONVERT(INT, TotalAbsenceTaken) FROM ( SELECT EmployeeID,sum(TotalAbsenceTaken)AS TotalAbsenceTaken  FROM dbo.PHRPA0018 WHERE SUBSTRING(StartDate, 0, 5)  = '2021' AND AbsenceType IN ('1000', '1100', '1001', '1111')
3 
GROUP BY EmployeeID)a WHERE a.EmployeeID = PHRPA0017.EmployeeID AND (PHRPA0017.StartDate = '20210101' AND PHRPA0017.EndDate='20220331')
(2-2/2)