大力的先入先出的库存物品，按批次出货的问题的一个解法。

<script type="text/javascript"> </script> <script type="text/javascript" src="http://pagead2.googlesyndication.com/pagead/show_ads.js"> </script>

<script type="text/javascript"> </script><script type="text/javascript" src="http://pagead2.googlesyndication.com/pagead/show_ads.js"> </script>

createtableG(goodsvarchar(2),lotvarchar(3),balint)
createtableO(oidvarchar,goodsvarchar(2),qtyint)
insertGselect'aa','p01',5
  unionselect'aa','p02',10
  unionselect'bb','p01',20

insertOselect'1','aa',11
  unionselect'1','bb',10
  unionselect'2','aa',2
  unionselect'3','aa',1

selectoid,b.goods,lot,deli=(casewhensq>sbthensbelsesqend)-(casewhensq-qty<sb-balthensb-balelsesq-qtyend)
from(select*,sq=(selectsum(qty) 
                            fromo
                            whereoid<=a.oidandgoods=a.goods
                          )
      fromoa
    )b
    join
    (select*,sb=(selectsum(bal)
                             fromg
                             wheregoods=a.goodsandlot<=a.lot
                           )
      fromga
    )c
    onb.goods=c.goodsandsq-qty<sbandsq>sb-bal
orderbyoid,b.goods,lot

droptableg,o
<script type="text/javascript"> </script> <script type="text/javascript" src="http://pagead2.googlesyndication.com/pagead/show_ads.js"> </script>

<script type="text/javascript"> </script><script type="text/javascript" src="http://pagead2.googlesyndication.com/pagead/show_ads.js"> </script>