--1、将对应商品档案数据插入临时表(仅处理无出入库记录和淘汰商品)
SELECT  *
INTO    t_bd_Item_eliminate
FROM    t_bd_item_Info
WHERE   item_No NOT IN ( SELECT DISTINCT
                                item_no
                         FROM   t_im_flow )
                         
-- 2、将对应供应商商品表数据插入临时表
select *  into t_bd_supcust_item_eliminate
 from t_bd_supcust_item
  where   item_No in  (select item_No from t_bd_Item_eliminate )
go

--3、将对应商品机构价格表数据插入临时表
select *  into t_pc_branch_price_eliminate
 from t_pc_branch_price
  where   item_No in  (select item_No from t_bd_Item_eliminate )
go

--4、删除供应商商品表
delete from t_bd_supcust_item where item_No in (select item_No from t_bd_Item_eliminate )
go

--5、删除机构价格表中的信息.
delete from t_pc_branch_price where  item_No in  (select item_No from t_bd_Item_eliminate )
go

--6、删除基本档案
delete from  t_bd_item_Info  where  item_No in  (select item_No from t_bd_Item_eliminate )
GO