参考楼上的。强制交班语句如下：

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