752
社区成员
发帖
与我相关
我的任务
分享广招英雄贴:输入日期,查询,内容为每天17点之前的个人业绩总额
SELECT
sum(dpxstz.xssl) as t_xssl,
sum(dpxstz.cxsje) as t_xsje,
sum(dpxstz.xj) as t_xj,
sum(dpxstz.ysk) as t_ysk,
sum(dpxstz.sswr) as t_sswr,
sum(dpxstz.xszk) as t_xszk,
dpxstz.hth,
bmda.bmmc
FROM dpxstz ,bmda
WHERE dpxstz.bmh=bmda.bmh and
( ( dpxstz.bmh like :部门号 ) and
( dpxstz.rq >= :开始日期 ) and
( dpxstz.rq <= :结束日期 ) )
group by dpxstz.hth,bmda.bmmc
sum(dpxstz.xssl) as t_xssl,
sum(dpxstz.cxsje) as t_xsje,
sum(dpxstz.xj) as t_xj,
sum(dpxstz.ysk) as t_ysk,
sum(dpxstz.sswr) as t_sswr,
sum(dpxstz.xszk) as t_xszk,
dpxstz.hth,
bmda.bmmc
FROM dpxstz ,bmda
WHERE dpxstz.bmh=bmda.bmh and
( ( dpxstz.bmh like :部门号 ) and
( dpxstz.rq >= :开始日期 ) and
( dpxstz.rq <= :结束日期 ) )
group by dpxstz.hth,bmda.bmmc
...全文
请发表友善的回复…
发表回复
lzuyh 2007-04-02
- 打赏
- 举报
关注
jdsnhan 2007-04-02
- 打赏
- 举报
可以让数据库自己来完成，如job
也可以借助操作系统来完成，如window的计划任务等等
也可以借助操作系统来完成，如window的计划任务等等
tmc1703 2007-03-30
- 打赏
- 举报
统计还是很简单的吧,关键是怎么能够定时执行,我们现在的办法是写一个windows service.不知道楼主是怎么实现的?
sunxiaobo 2007-03-30
- 打赏
- 举报
SELECT
sum(dpxstz.xssl) as t_xssl,
sum(dpxstz.cxsje) as t_xsje,
sum(dpxstz.xj) as t_xj,
sum(dpxstz.ysk) as t_ysk,
sum(dpxstz.sswr) as t_sswr,
sum(dpxstz.xszk) as t_xszk,
dpxstz.hth,
bmda.bmmc
FROM dpxstz ,bmda
WHERE dpxstz.bmh=bmda.bmh and
( ( dpxstz.bmh like :部门号 ) and
( dpxstz.rq >= :开始日期 ) and
( dpxstz.rq <= :结束日期 ) ) and DATEPART(hour, dpxstz.rq)<=17
group by dpxstz.hth,bmda.bmmc
sum(dpxstz.xssl) as t_xssl,
sum(dpxstz.cxsje) as t_xsje,
sum(dpxstz.xj) as t_xj,
sum(dpxstz.ysk) as t_ysk,
sum(dpxstz.sswr) as t_sswr,
sum(dpxstz.xszk) as t_xszk,
dpxstz.hth,
bmda.bmmc
FROM dpxstz ,bmda
WHERE dpxstz.bmh=bmda.bmh and
( ( dpxstz.bmh like :部门号 ) and
( dpxstz.rq >= :开始日期 ) and
( dpxstz.rq <= :结束日期 ) ) and DATEPART(hour, dpxstz.rq)<=17
group by dpxstz.hth,bmda.bmmc
