use hbposev9_branch go select * into t_rm_daysum20160728 from t_rm_daysum where pre_qty<>(sale_qty+giv_qty-ret_qty) and other1='1' update t_rm_daysum set sale_qty=pre_qty where pre_qty<>(sale_qty+giv_qty-ret_qty) and other1='1' go
