DECLARE @now VARCHAR(8) 
SET @now = dbo.fn_formatdatetime(GETDATE(), 'yyyymmdd')

DECLARE @toinsertmd125 TABLE
        (
		 EmployeeID VARCHAR(20)
           ,StartDate VARCHAR(20)
           ,EndDate VARCHAR(20)
           ,DayType VARCHAR(20)
           ,PublicHoliday VARCHAR(20)
		   ,Notes VARCHAR(50)
           ,CreateBy VARCHAR(50)
           ,CreateDate VARCHAR(50)
           ,ChangeBy VARCHAR(50)
           ,ChangeDate VARCHAR(50)
        )
	insert into @toinsertmd125
select  md25.EmployeeID, cal.DateSpecified, cal.DateSpecified,cal.DayType,cal.PublicHoliday, '','system' ,  FORMAT(getdate(),'yyyyMMddHHmmss'), 'system',FORMAT(getdate(),'yyyyMMddHHmmss') from PHRPA0025 md25
left join PHRTMWSCAL cal on md25.WorkScheduleType = cal.WorkScheduleType 
              and cal.year= '2024'
where md25.WorkScheduleType = '5D8H' 
-- filter berdasarkan generate ws pertahun
--and md25.StartDate = '20240101'
-- filter berdasarkan generate lebih dari 1 tahun dan hanya yg aktif saja yaitu yg 99991231
AND md25.StartDate <= @now
AND md25.EndDate >= @now

INSERT INTO  dbo.PHRPA0125 
SELECT DISTINCT  [StartDate],[EndDate],[EmployeeID],[DayType],[PublicHoliday],[Notes],[CreateBy],[CreateDate],[ChangeBy],[ChangeDate] FROM @toinsertmd125