【问】门店销售时，商品没有价格。如何处理？
【适用版本】服装之星9	【模块】基础业务	【点击数】39
【知识编号】Z2016010800018
【问题描述】导入数据后。门店销售时，商品没有价格。如何处理？

【答】 请备份数据库后执行以下语句：
use hbfsv9
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 ,
          trans_price ,
          counter_id
        )
        SELECT  a.item_no ,
                b.branch_no ,
                ( CASE b.trade_type
                    WHEN ‘2’ THEN a.trans_price
                    ELSE a.price
                  END ) ,
                base_price ,
                sale_price ,
                vip_price ,
                vip_price2 ,
                vip_price3 ,
                vip_price4 ,
                vip_price5 ,
                trans_price ,
                counter_id = ‘9999’
        FROM    dbo.t_bd_item_info a ,
                t_bd_branch_info b
        WHERE   LEN(b.branch_no) = 2
                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 )