【问】商品销售时没有价格，如何更新机构价格表？
【适用版本】烘焙之星9	【模块】基础业务	【点击数】205
【知识编号】Z2015121800070
【问题描述】商品销售时没有价格，如何更新机构价格表？

【答】 请备份数据库后执行以下语句处理
–更新机构价格表
use issbakev9
go
select * into t_pc_branch_price_bak from t_pc_branch_price
go
INSERT  INTO t_pc_branch_price
            ( item_no ,
              branch_no ,
              price ,
              base_price ,
              sale_price ,
              vip_price ,
              vip_price2 ,
              vip_price3 ,
              vip_price4 ,
              vip_price5 ,
              scheme_price ,
              cost_price,
              sale_flag
              )
            SELECT  a.item_no ,
                    b.branch_no ,
                    ( CASE b.trade_type
                        WHEN ‘4’ THEN a.scheme_price
                        ELSE a.price
                      END ) ,
                    base_price ,
                    sale_price ,
                    vip_price ,
                    vip_price2 ,
                    vip_price3 ,
                    vip_price4 ,
                    vip_price5 ,
                    scheme_price ,
                    0.00,
                    a.sale_flag
            FROM    t_bd_item_info  a ,
                    t_bd_branch_info b
            WHERE   LEN(b.branch_no) = 3
                    AND NOT EXISTS ( SELECT 1
                                     FROM   t_pc_branch_price c
                                     WHERE  c.item_no = a.item_no
         AND c.branch_no = b.branch_no )