SELECT first 1 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
 