修复机构价格表语法

【问题答案】
请备份数据库后执行以下语句，如果前台连接的是分店，直接执行分店语句即可
use hbposev9
go
insert into t_pc_branch_price (branch_no,item_no,supcust_no,sale_way,price,
base_price,sale_price,vip_price,sup_ly_rate,branch_price,branch_sale,com_flag,item_stock,base_price1,base_price2,base_price3,base_price4)
Select b.branch_no,item_no,main_supcust,item_sup_flag,(case b.trade_type when '2' then a.trans_price else a.price end),
base_price,sale_price,vip_price,sup_ly_rate,branch_price,'1','0',item_stock,base_price1,base_price2,base_price3,base_price4
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 hbposev9_branch
go
insert into t_pc_branch_price (branch_no,item_no,supcust_no,sale_way,price,
base_price,sale_price,vip_price,sup_ly_rate,branch_price,branch_sale,com_flag,item_stock,base_price1,base_price2,base_price3,base_price4)
Select b.branch_no,item_no,main_supcust,item_sup_flag,(case b.trade_type when '2' then a.trans_price else a.price end),
base_price,sale_price,vip_price,sup_ly_rate,branch_price,'1','0',item_stock,base_price1,base_price2,base_price3,base_price4
From t_bd_item_info a,t_bd_branch_info b
Where b.property= '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)