2007-09-27 15:55:21
2007-09-12 16:04:52
网友问:如何按月进行统计公司采购进货、销售出库信息?
答:采购进货、采购退货;销售出库、销售退货按月统计;其实对于生产方面也就很容易扩展了。
select docYear, docMon, cast(sum(iQty) as numeric(22,2)) iQty, cast(sum(iAmt) as numeric(22,2)) iAmt, cast(sum(oQty) as numeric(22,2)) oQty, cast(sum(oAmt) as numeric(22,2)) oAmt
from
(
select datepart(yy,a.docdate) docYear, datepart(mm,a.docdate) docMon, sum(b.quantity) iQty, sum(b.quantity*price) iAmt, 0 oQty, 0.00 oAmt
from OPDN a inner join PDN1..
2007-08-31 11:32:02