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,(select * from t_bd_branch_info where LEN(branch_no)=4) 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)