----强制某一个工号交班，下面是将所有的操作员交班，根据需求改下。
----选择赢通数据帐套执行。
declare @deal_no varchar(20),@branch_no varchar(6),@today datetime
select @today= GetDate()
declare cur_deal cursor for
select distinct deal_no,branch_no from t_pos_deal_master where deal_status = '1' --and user_id='8001'
open cur_deal
fetch cur_deal into @deal_no,@branch_no
While @@fetch_status = 0
begin
exec pr_pos_deal_over @deal_no
fetch cur_deal into @deal_no,@branch_no
End
Close cur_deal
deallocate cur_deal

问题补充：一般在站点设置中按ctrl+F2即可强制交班。。


----当班单丢失导致交不了班

INSERT t_pos_deal_master(deal_no,branch_no,deal_class,user_id,jh,start_date,start_amt,deal_status,update_branch)
SELECT deal_no,LEFT(branch_no,2),deal_class,user_id,jh,DATEADD(minute,-1,MIN(sale_time)),0,1,LEFT(branch_no,2) FROM t_pos_sale_master WHERE deal_no NOT IN ( SELECT deal_no FROM dbo.t_pos_deal_master ) GROUP BY deal_no,deal_class,user_id,branch_no,jh
go