Skip to main content

Documentation Index

Fetch the complete documentation index at: https://docs.on-it.no/llms.txt

Use this file to discover all available pages before exploring further.

​
Visma Business

SELECT ...
    deltmb.deldt ExpectedDeliveryDate,
    deltmb.inpurc ExpectedDeliveryQuantity
FROM Prod
...
OUTER APPLY (
	SELECT TOP 1 convert(VARCHAR(max), dbo.GetDateO(deldt, 0), 105) deldt
		,inpurc
	FROM DelTmBal d
	CROSS JOIN GetDateHelper
	WHERE d.ProdNo = prod.prodno
		AND dbo.GetDateO(DelDt, 0) > GetDateHelper.NowDate
	ORDER BY deldt ASC
	) deltmb