

SELECT 0 WACCOUNTID, a.WSTOCKID , a.FUNTILQTY1 + 1 FROMQTY, a.FUNTILQTY2 FQTY, a.FPRICE2 FPRICE1, b.FUNITCOST
FROM PRICE_AGREEMENT a join stock b on a.wstockid = b.wstockid where a.WSTOCKID = <@WSTOCKID@>
and FUNTILQTY2 > 0

union

SELECT 0 WACCOUNTID, a.WSTOCKID , a.FUNTILQTY2 + 1 FROMQTY, a.FUNTILQTY3 FQTY, a.FPRICE3 FPRICE1, b.FUNITCOST
FROM PRICE_AGREEMENT a join stock b on a.wstockid = b.wstockid where a.WSTOCKID = <@WSTOCKID@>
and FUNTILQTY3 > 0

union

SELECT 0 WACCOUNTID, a.WSTOCKID , a.FUNTILQTY3 + 1 FROMQTY, a.FUNTILQTY4 FQTY, a.FPRICE4 FPRICE1, b.FUNITCOST
FROM PRICE_AGREEMENT a join stock b on a.wstockid = b.wstockid where a.WSTOCKID = <@WSTOCKID@>
and FUNTILQTY4 > 0

union

SELECT 0 WACCOUNTID, a.WSTOCKID , a.FUNTILQTY4 + 1 FROMQTY, a.FUNTILQTY4 FQTY, a.FPRICE5 FPRICE1, b.FUNITCOST
FROM PRICE_AGREEMENT a join stock b on a.wstockid = b.wstockid where a.WSTOCKID = <@WSTOCKID@>
and FUNTILQTY4 > 0
