Question

sql存储过程，查询一个时间段内的挂号人数，金额，按照课科室统计，基本代码怎么写的，初学者不太明白

create procedure usp_gh_rcje
@ksrq ut_rq16,
@jsrq ut_rq8
as
set nocount on select sum(a.xmsl) as 挂号人数 from GH_GHMXK as a,GH_GHZDK as b
where a.xh=b.xh and b.ghrq between '20160701' and '20160720' and b.ksdm='3201'

select sum(a.zje) as 总金额 from SF_BRJSK as a,GH_GHZDK as b
where a.blh = b.blh and b.ghrq between '20160701' and '20160720' and a.ksdm= '3201'

select distinct * from GH_GHZDK as GH_GHK
where ksdm='3201'
这是我写的，但是老师说不对，让我再修改

Answer 1

--按你的要求要 按照科室 查询一个时间段的挂号人数，你的参数至少要有 开始时间，结束时间，科室 三个参数. 
--而且你的过程中根本没有使用你定义的参数@ksrq 和@jsrq,你只是写出了几条语句而已

Answer 2

按照科室统计可以用group by分组，你先试试效果看看是不是你要的。
select sum(a.xmsl) as 挂号人数,ksdm as 科室 from GH_GHMXK as a,GH_GHZDK as b
where a.xh=b.xh and b.ghrq between '20160701' and '20160720' group by ksdm
select sum(a.zje) as 总金额,ksdm AS 科室from SF_BRJSK as a,GH_GHZDK as b
where a.blh = b.blh and b.ghrq between '20160701' and '20160720' GROUP BY ksdm

Answer 3

是不会写存储过程 还是不会写sql??

Answer 4

你的表结构贴出来