quote:

---

Msg 512, Level 16, State 1, Line 4
Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.

---

SELECT TOP 1 
	@skuVar, CAST(GETDATE()-ReceivedOn AS INT) AS 'Age' 
FROM 
	(SELECT pir.id AS id,aggregateQty AS aggregateQty,-qtyreceived as qtyreceived, (aggregateQty - qtyreceived) AS Diff, ReceivedOn AS ReceivedOn 
	
	,(
	SELECT SUM (PurchaseItemReceive.qtyreceived)
	FROM bvc_product pp
	INNER JOIN PurchaseItemReceive on PurchaseItemReceive.ProductID = pp.id
	WHERE pp.ID = p.id
		AND PurchaseItemReceive.ReceivedOn  < pir.ReceivedOn
	GROUP BY PurchaseItemReceive.qtyreceived
	) as 'preCalc'
	
	,(
	SELECT SUM (PurchaseItemReceive.qtyreceived)
	FROM bvc_product pp
	INNER JOIN PurchaseItemReceive on PurchaseItemReceive.ProductID = pp.id
	WHERE pp.ID = p.id
		AND PurchaseItemReceive.ReceivedOn  < pir.ReceivedOn
	GROUP BY PurchaseItemReceive.qtyreceived
	)-AggregateQty as 'CalcNum'

	FROM bvc_product p
	INNER JOIN PurchaseItemReceive pir on pir.ProductID = p.id
	WHERE p.ID = @skuVar
	) A
WHERE CalcNum < 0