更新时间:2022-12-22 13:37:21
感谢大家的宝贵时间和精力,我得到了答案....
声明@P_Date表
(
[P_Date]日期
)
插入@P_Date选择distinct [P_Date]
FROM [Zultime]。[dbo]。[TIME_SHEET] INSERT INTO Tbl_EmpNotPunching
s选择[Pin_Code],P_Date,'07:30'作为PunchIN,'16:30'作为打孔
来自[AttendanceCorrection]。[dbo]。[Tbl_FMOEmp]
交叉加入@P_Date
Thanks everyone for your valuable time and effort i got my answer....
declare @P_Date table
(
[P_Date] date
)
insert into @P_Date select distinct [P_Date]
FROM [Zultime].[dbo].[TIME_SHEET] INSERT INTO Tbl_EmpNotPunching
select [Pin_Code], P_Date, '07:30' as PunchIN, '16:30' as punchOUT
FROM [AttendanceCorrection].[dbo].[Tbl_FMOEmp]
cross join @P_Date