DELETE FROM #TempCountLP
	FROM   #TempCountLP S
	WHERE  NOT EXISTS (SELECT 1
					   FROM   "8002".tbCountTable zb,
							  "8002".tbCountTableDetail cb
					   WHERE  zb.BillNumber = cb.BillNumber
							  AND zb.CountID = 114
							  AND CounterCode = S.CounterCode
							  AND LocationCode = S.LocationCode
							  AND GoodsCode = S.GoodsCode)