将每日输入明细插入到考勤表与工资表

来源：互联网发布：javascript面试题目编辑：程序博客网时间：2024/06/10 17:29

create procedure Hhwtdaypay @fid int
--将每日输入明细插入到考勤表与工资表
--插入考勤
declare @at varchar(20) set @at=CONVERT(varchar(100), GETDATE(), 23)
INSERT INTO [Hwt]([fid],[date1],[m1],[iDNO],[workhour],[zm1]
,[zm2],[createPerson],[createdate])
select [fid],[date1],[m1],[iDNO],[workhour],[zm1]
,[zm2],[createPerson],@at
from Hpayenter where fid = @fid
--插入工资
INSERT INTO [Hdaypay]([fid],[cODE],[mitem],[uprice],[qty],[summoney]
,[cmemo],[createperson],[createdate])
select [fid],[cODE],[mitem],[uprice],[qty],[summoney]
,[cmemo],[createperson],@at from Hpayenterson
where fid= @fid
create procedure Hhwtdaypay @fid int
--将每日输入明细插入到考勤表与工资表
--插入考勤
as --少了此as
declare @at varchar(20) set @at=CONVERT(varchar(100), GETDATE(), 23)
INSERT INTO [Hwt]([fid],[date1],[m1],[iDNO],[workhour],[zm1]
,[zm2],[createPerson],[createdate])
select [fid],[date1],[m1],[iDNO],[workhour],[zm1]
,[zm2],[createPerson],@at
from Hpayenter where fid = @fid
--插入工资
INSERT INTO [Hdaypay]([fid],[cODE],[mitem],[uprice],[qty],[summoney]
,[cmemo],[createperson],[createdate])
select [fid],[cODE],[mitem],[uprice],[qty],[summoney]
,[cmemo],[createperson],@at from Hpayenterson
where fid= @fid