today:
413
yesterday:
400
Total:
1,744,763

Technology

CREATION DEDUCTION TYPE

admin 2020.10.17 04:10 Views : 89

BEGIN

 

DELETE FROM DEDUCTION_YEAR;

 

INSERT INTO DEDUCTION_YEAR (DTYPEID)

Select DTID from DEDUCTION_TYPE

WHERE ACTIVE = 'A'

ORDER BY DTID;

 

COMMIT;

END;