DECLARE @ModelStore VARCHAR(8)

SET @ModelStore = 'North'

;with nonmodelStores as (select storeID from #Stores where StoreID<>@ModelStore),

nonmodelinv as (select storeID, productID from #StoreInventory where StoreID<>@ModelStore),

modelinv as (select storeID, productID from #StoreInventory where StoreID=@ModelStore),

IdealizedInv as (select nms.storeid,mi.productID from modelinv mi cross join nonmodelStores nms)

(

select storeid,productID, 'purchase' actionname from IdealizedInv

except

select storeid,productID, 'purchase' actionname from nonmodelinv)

union

(

select storeid,productID, 'liquidate' actionname from nonmodelinv

except

select storeid,productID, 'liquidate' actionname from IdealizedInv)