CLIENT SUPPORT » BBG Bugs

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