27,579
社区成员
发帖
与我相关
我的任务
分享
--更正一下
set mid=1
改成set isExcept=1
CREATE PROCEDURE test
AS
declare @childid int,@mid int,@yymmdd varchar(20),@cardtime varchar(20),@empid int,@isExcept int,
@v_childid int,@v_mid int,@v_yymmdd varchar(20),@v_cardtime varchar(20),@v_empid int,@v_isExcept int
BEGIN
declare cur_busin cursor for
select *from EMRealMonitor
open cur_busin
fetch next from cur_busin
into @childid,@mid,@yymmdd,@cardtime,@empid,@isExcept
while @@fetch_status=0
begin
if @v_empid=@empid and (@v_yymmdd>@yymmdd or (@v_yymmdd=@yymmdd and datediff(s,cast(@v_cardtime as datetime),cast(@cardtime as datetime))>10))
begin
update EMRealMonitor
set mid=1
where empid=@empid
and id=@v_childid
end
end
END