如何显示当天所有产品的数量？
----建立测试数据----环境：MSSQL2000if exists (select * from sysobjects where id = object_id(N'T_testJxc') and OBJECTPROPERTY(id, N'IsUserTable') = 1)begin drop table T_testJxcendCREATE TABLE [T_testJxc] ( [fdId] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL , [fdNumber] [float] NULL , [fdCz] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL , [fdcf] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL , [fdDate] [datetime] NULL , [fdCheck] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ) ON [PRIMARY]GOInsert T_Testjxc (fdId,fdNumber,fdCz,fdcf,fdDate,fdCheck) Values ( '001',1.000000000000000e+001,'JH','A仓','2012-07-01 00:00:00.000','已审核')Insert T_Testjxc (fdId,fdNumber,fdCz,fdcf,fdDate,fdCheck) Values ( '001',-7.000000000000000e+000,'XL','A仓','2012-07-01 00:00:00.000','已审核')Insert T_Testjxc (fdId,fdNumber,fdCz,fdcf,fdDate,fdCheck) Values ( '002',1.000000000000000e+001,'JH','A仓','2012-07-01 00:00:00.000','已审核')Insert T_Testjxc (fdId,fdNumber,fdCz,fdcf,fdDate,fdCheck) Values ( '001',5.000000000000000e+000,'JH','A仓','2012-07-02 00:00:00.000','已审核')select * from T_testJxcgo --------------------以下是尝试作一个查询处理，但不是我所要 要求的结果 select convert(char(10),fdDate,120) as 日期, [fdId] as 编号, [fdcf] as 仓库, [期初库存]=isnull((select sum(fdNumber) from T_testJxc where [fdId]=a.[fdId] and [fdcf]=a.[fdcf] and [fdDate]<a.[fdDate]),isnull((select top 1 fdNumber from T_testJxc where [fdId]=a.[fdId] order by [fdDate]),0)), sum(case when [fdCz]='JH' then [fdNumber] else 0 end) as [进货], sum(case when [fdCz]='XL' then [fdNumber] else 0 end) as [出货], [期末库存]=(select SUM(fdNumber) from T_testJxc where [fdId]=a.[fdId] and [fdcf]=a.[fdcf] and [fdDate]<=a.[fdDate]) from T_testJxc a group by [fdDate],[fdId],[fdCf]
