gh.txt

欢迎使用

---------------------------------------------------------------------
请尊重他人的劳动成果
---------------------------------------------------------------------


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