SELECT top 1 b.quantity
FROM OPOR a left join POR1 b ona.docentry=b.docentry
WHERE b.itemcode= $[$38.1.0]
ORDER BY a.docdate desc
SELECT top 1 * FROM (SELECT top 2 b.quantity,a.docdate
FROM OPOR aleft join POR1 b on a.docentry=b.docentry
WHERE b.itemcode=$[$38.1.0]ORDER BY a.docdate desc) tb1
ORDER BY tb1.docdate
SELECT top 1 * FROM (SELECT top 3 b.quantity,a.docdate
FROM OPOR a left join POR1 b ona.docentry=b.docentry
WHERE b.itemcode=$[$38.1.0] ORDER BY a.docdatedesc) tb1
ORDER BY tb1.docdate