27,582
社区成员




Select T_STUDY_REPORT.F_STU_REFER_DOCTOR As 送诊医生,T_STUDY_BASIC.F_STU_DEV_SIGN as 设备型号,Count(T_STUDY_BASIC.F_STU_GUID) As [检查量(人数)],sum(Len(T_STUDY_REPORT.F_STU_BODY_PART)-Len(replace(T_STUDY_REPORT.F_STU_BODY_PART,'+',''))+1) AS 检查部位数,Sum(T_STUDY_STAT.F_STU_FARE) As 费用 From [数据表] Where [日期:T_STUDY_BASIC.F_STU_DATE] and (T_STUDY_BASIC.F_STU_DEV_SIGN like '%磁共振%' or T_STUDY_BASIC.F_STU_DEV_SIGN='MR' ) Group By T_STUDY_REPORT.F_STU_REFER_DOCTOR,T_STUDY_BASIC.F_STU_DEV_SIGN
select a.送诊医生,a.设备型号,Count(a.F_STU_GUID) as [检查量(人数)],sum(Len(a.检查部位)-Len(replace(a.检查部位,'、',''))+1) AS 检查部位数,Sum(a.F_STU_FARE) As 费用 from (Select T_STUDY_REPORT.F_STU_REFER_DOCTOR As 送诊医生 ,T_STUDY_BASIC.F_STU_DEV_SIGN as 设备型号,T_STUDY_BASIC.F_STU_GUID,case when CHARINDEX('(',T_STUDY_REPORT.F_STU_BODY_PART)>0 then REPLACE(T_STUDY_REPORT.F_STU_BODY_PART,SUBSTRING(T_STUDY_REPORT.F_STU_BODY_PART,
CHARINDEX('(',T_STUDY_REPORT.F_STU_BODY_PART),
CHARINDEX(')',T_STUDY_REPORT.F_STU_BODY_PART)-CHARINDEX('(',T_STUDY_REPORT.F_STU_BODY_PART)+1)
,'') else T_STUDY_REPORT.F_STU_BODY_PART end as 检查部位,T_STUDY_STAT.F_STU_FARE From [数据表] Where [日期:T_STUDY_BASIC.F_STU_DATE] and T_STUDY_BASIC.F_STU_DEV_SIGN like '%CT%') a Group By a.送诊医生,a.设备型号
心情还比较好,毕竟客户用起来方便了,呵呵。