Suppose I have a table taking care of incoming:
Date amount unit_price($)
01/01/05 5 7
01/02/05 4 2
01/03/05 6 3
01/04/05 3 6
01/05/05 8 1
Also have a table taking care of outgoing:
Date amount cost($)
01/01/05 2
01/02/05 7
01/03/05 6
01/04/05 3
01/05/05 4
I would like to define the outgoing cost using "First in First out", so the
cost should be calculated as:
Date amount cost($)
01/01/05 2 2*$7
s******n 发帖数: 45
2
simple query can't do this bah? at least u need a sproc with cursor...
【在 b*****o 的大作中提到】 : Suppose I have a table taking care of incoming: : Date amount unit_price($) : 01/01/05 5 7 : 01/02/05 4 2 : 01/03/05 6 3 : 01/04/05 3 6 : 01/05/05 8 1 : Also have a table taking care of outgoing: : Date amount cost($) : 01/01/05 2
