insert into dbo.DeliveryBranchItem(DeliveryBranchId,BranchId,ItemId,ItemStatus)
select distinct a.DeliveryBranchId, a.Id, b.Id,b.ItemStatus
from dbo.Branch a, Item b
where  a.Property not in (0,1,6,9)--排除总部,配送中心,加盟商,仓库
and isnull(a.DeliveryBranchId, '') <> ''
and b.ItemStatus <>'2'
and not exists ( select 1 from DeliveryBranchItem db where db.BranchId=a.Id and db.itemid = b.Id)   --添加配送中心商品关系