Copy update append records to a table based on another one

[Kristen]

@Patyk

Is there a way around it?

The suggestion that I made in your other thread ...

Need help with Store Procedure

The Code below works fine for my procedure. But I need to make an addition. First is the StockCode and Price Code exist in companyB.dbo.invPrice and EndDate < CurrentDate I need to delete this record from companyB,invPrice and update ImportedPromoPricing.Completed to D Second if I add a record from ImportedPromoPricing then I need to update ImportedPromoPricing.Completed to Y Initial procedure is below. begin insert into companyB.dbo.InvPrice ([invprice].[StockCode],[invprice].[PriceCode]…