|

楼主 |
发表于 2010-1-29 18:08:38
|
显示全部楼层
楼上的,你看下我的存储过程就知道了
Drop proc 消防检验情况汇总
--检验情况汇总(消防)
CREATE proc 消防检验情况汇总 @BeginDate datetime,@EndDate datetime
as
Select a.BGBH as 检验编号,a.SJDW as 受检单位,a.YPMC as 样品名称,
a.SYRQ as 收样日期,a.QFRQ as 签发日期,a.PD as 检验结论,
a.RWLY as 消防主管部门名称,a.JYF as 检验费,
a.LCZT as 流程状态,a.ZYKS as 主检科室,a.JYLX as 检验类型,a.dq as 地区, --辅助条件字段
已收费=(Select SUM(SF) from SFKDJB where SFKDJB.BGBH=a.BGBH), --辅助条件字段
收费情况=(Select Count(*) from SFKDJB where SFKDJB.BGBH=a.BGBH) --辅助条件字段
from jydb a
where DYRQ>=@BeginDate and DYRQ<dateadd(dd,+1,@EndDate)
GROUP BY a.BGBH,a.SJDW,a.YPMC,a.SYRQ,a.QFRQ,a.PD,a.RWLY,a.JYF,a.LCZT,a.ZYKS,a.JYLX,a.dq
Go |
|