gistfile1.sql

WITH prodord AS (
	SELECT po_type, prodord.a_nr, a_sats, po_kvant, po_rappkv
	FROM dbo.art
	JOIN dbo.prodord ON prodord.a_nr = art.a_nr
	WHERE vgr_id < 'K' AND po_status = 4 AND art.k_nr = 18550
), viadata AS (
	SELECT
		po_kvant, res_rappkv, po_rappkv * (res_kvant / po_kvant) AS rapp_kv, 
		CASE a_aktkpris WHEN 1 THEN a_kpris1 WHEN 2 THEN a_kpris2 WHEN 3 THEN a_kpris3 WHEN 4 THEN a_kpris4 END / a_innpenh AS a_kpris
	FROM prodord
	JOIN dbo.reserv ON reserv.a_nr = prodord.a_nr AND reserv.a_sats = prodord.a_sats AND reserv.po_type = prodord.po_type
	JOIN dbo.art ON art.a_nr = reserv.res_a_nr
), via AS (
	SELECT CASE WHEN po_kvant = 0 OR res_rappkv < rapp_kv THEN 0 ELSE a_kpris * (res_rappkv - rapp_kv) END AS via_kpris
	FROM viadata
)
SELECT SUM(via_kpris) FROM via