Page History

--select only:

select 
	--S.StockLink
	--,S.Code, S.Description_1, 
	S.*
	INTO StkItem_Deleted311022_b
	from StkItem S
	LEFT JOIN (SELECT STockId, SUM(QtyOnHand) QOH FROM _etblStockQtys GROUP BY StockID) t ON S.StockLink = t.StockID
	LEFT JOIN _etblStockCosts SD ON SD.StockID = S.StockLink AND SD.WhseID = -1
	--LEFT JOIN (SELECT AccountLink, count(*) cnt from PostST group by AccountLink) x on S.StockLink = x.AccountLink
	where  S.StockLink IN (SELECT AccountLink FROM PostST WHERE TxDate >= '2020-12-01')
			and S.StockLink NOT IN (SELECT AccountLink FROM PostST WHERE TxDate >= '2022-01-01')
		and COALESCE(t.QOH,0) = 0 
		and S.StockLink NOT IN (select iStockCodeID from _btblInvoiceLines il left join invnum i on il.iinvoiceid = i.autoindex where i.orderdate > dateadd(day,-180,getdate()))
		and S.ItemActive = 1