更新分店价格机构表。
【问题答案】
备份好数据执行以下，根据商品档案表中的价格同步更新机构价格表的价格。
use hbmsv7
go
insert into t_pc_branch_price (branch_no,item_no,price,
base_price,sale_price,vip_price,com_flag)
Select b.branch_no,item_no,price,
base_price,sale_price,vip_price,'0'
From t_bd_item_info a,t_bd_branch_info b
Where b.property in ('0','1')
And b.branch_no+item_no not in (select c.branch_no+c.item_no from t_pc_branch_price c
where c.branch_no=b.branch_no and c.item_no = a.item_no)
go
【问题答案】
备份好数据执行以下，根据商品档案表中的价格同步更新机构价格表的价格。
use hbmsv7
go
insert into t_pc_branch_price (branch_no,item_no,price,
base_price,sale_price,vip_price,com_flag)
Select b.branch_no,item_no,price,
base_price,sale_price,vip_price,'0'
From t_bd_item_info a,t_bd_branch_info b
Where b.property in ('0','1')
And b.branch_no+item_no not in (select c.branch_no+c.item_no from t_pc_branch_price c
where c.branch_no=b.branch_no and c.item_no = a.item_no)
go
