---------------------------------------------------------------------
请尊重他人的劳动成果
---------------------------------------------------------------------
declare
@day_begin datetime,
@day_end datetime,
@enter_name varchar(10),
@op_id varchar(10)
set @day_begin='2005-06-12'
set @day_end = '2005-06-12'
set @op_id = '00000'
/*
set @day_begin=:day_begi
set @day_end = :day_end
set @enter_name = (select name from a_employee_mi where emp_sn =:op_id)
*/
select u.name 科室,count(v.clinic_type) 人次
from view_mz_visit_table v, zd_unit_code u,gh_zd_clinic_type c,a_employee_mi e
where datediff(dd, v.visit_date, @day_begin)<=0
and datediff(dd, v.visit_date, @day_end)>=0
and (v.visit_flag <> '9')
and (v.visit_flag is not null)
and (case when len(v.visit_dept)=7 then visit_dept else '0000000' end *= u.unit_sn)
and (case when len(v.doctor_code)=5 then doctor_code else '00000' end *= e.emp_sn)
and v.clinic_type = c.code
group by u.name,c.name,e.name
order by u.name
--select * from a_patient_mi
--select * from zd_unit_code
--select * from ba_field_control **
--select * from view_zy_allpatient where patient_id='000000002700'
--select * from view_zy_allpatient where inpatient_no='138203'
--select * from view_zy_allpatient where name='郭波'
--select * from zy_actpatient
--select * from ba_first_page6
--select * from zd_sex_code
--select * from a_employee_mi
--select * from gh_detail_charge
--select * from zy_deposit_file where depo_amount='1000' 病人交款记录
--select * from zy_patient_total_charge 病人费用表
--select * from zy_actpatient
--select * from zy_receipt_charge