天下广发英雄贴:某一时间段5点前的个人总业绩显示出来

[leadxyq]

我需要用的是计算每个人员工下午5点之前的个人的业绩 输入开始和结束日期,就会把某一时间段5点钱的总业绩显示出来，求如何解决,下面是我PB编程遇见的问题.望高手解答. 注意下面的时间格式

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 right(convert(varchar(13) , rq , 120),2) <= '17'

group by dpxstz.hth,bmda.bmmc


这样不行啊 是不是right(convert(varchar(13) , rq , 120),2) <= '17'
这个语句有问题?没查询结果的

我的rq 日期格式是
2007-03-0X 00:00:00.000
sj 时间格式
2007-03-0X 17:00:00.000

[dawugui]

SELECT
dpxstz.hth,
bmda.bmmc,
convert(varchar(10),rq,120),
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
FROM dpxstz ,bmda
WHERE
dpxstz.bmh=bmda.bmh and
( dpxstz.rq >= :开始日期 ) and
( dpxstz.rq <= :结束日期 ) and
right( convert(varchar(13) , rq , 120) , 2) <= '17'
group by hth,bmmc,convert(varchar(10),rq,120)