TA的每日心情 | 开心 2015-3-23 09:22 |
---|
签到天数: 10 天 [LV.3]偶尔看看II
|
楼主 |
发表于 2009-10-23 09:17:50
|
显示全部楼层
有些进展
使用如下SQL语句可以看到仓库所在地,但相关的时间是对其最后的操作日期,暂时还无法获知入库日期。
SELECT DISTINCT
TOP (100) PERCENT dbo.goodstype.name AS 类别, dbo.goods.name AS 名称, dbo.goods.specs AS 规格,
SUM(dbo.detailbillflow.inqty - dbo.detailbillflow.outqty) AS 数量, dbo.goods.aprice AS 单价, MAX(DISTINCT dbo.detailbillflow.billdate) AS 入库日期,
dbo.store.name AS 仓库
FROM dbo.detailbillflow INNER JOIN
dbo.goods ON dbo.detailbillflow.goodsid = dbo.goods.goodsid INNER JOIN
dbo.store ON dbo.detailbillflow.storeid = dbo.store.storeid INNER JOIN
dbo.goodstype ON dbo.goods.goodstypeid = dbo.goodstype.goodstypeid
WHERE (dbo.detailbillflow.billtype <> 20) AND (dbo.detailbillflow.billtype <> 12)
GROUP BY dbo.store.name, dbo.goods.name, dbo.goods.aprice, dbo.goodstype.name, dbo.goods.specs
HAVING (SUM(dbo.detailbillflow.inqty - dbo.detailbillflow.outqty) > 0))
数据库环境是SQL2008 EXPRESS |
|