可用语句1查询相关单据,语句2删除,语句1时间改为实际日结开始结束时间,语句2单号改为1查询出的单号,注意备份数据库
use issfoodv6
----1、可查询出对应的单据
select * from cybr_u_tmp_orderdish_qu where isnull ( ch_payflag , 'N' ) in ( 'Y' ) and isnull ( ch_billno_old , '' ) ='' and isnull ( ch_print , 'N' ) <> 'O' and dt_operdate >= '2016-7-19 23:39:2.000' and dt_operdate <= '2016-7-21 6:0:0.000'
----2、删除对应单号
delete from cybr_u_tmp_orderdish_qu where ch_billno= '单号'
08-30
5437