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

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