【问】流水数据合计错误。 | ||
【适用版本】专卖店8 | 【模块】基本档案 | 【点击数】39 |
【知识编号】Z2012052200050 | ||
【问题描述】流水数据手工计算得出的合计与软件不符? |
请备份数据库后,在总部执行如下语句:
use isszmv8
go
delete t_sys_data_grant
insert into t_sys_data_grant (oper_id,item_clsno)
select oper_id,item_clsno from t_sys_operator,t_bd_item_cls where len(item_clsno)=2 and oper_id not in (select oper_id from t_sys_data_grant);
update t_sys_data_grant set data_grant = ‘1’ where oper_id = ‘1001’