quote:

---

create table #a (partID int)
insert #a select PartID from products where bikeId = @bikeID

begin tran
update shopping_cartItems
set partQty = partQty + 1
from #a
where #a.partId = shopping_cartItems.partId
and shopping_cartItems.cartId = @cartId

delete #a
from shopping_cartItems
where #a.partId = shopping_cartItems.partId
and shopping_cartItems.cartId = @cartId

insert shopping_cartItems
select ...
from #a

commit tran

---