22,207
社区成员
发帖
与我相关
我的任务
分享
SELECT Departcode='1000',departname='医院',EmployCode='',realname='医院总计',sum(expenses) expenses,sum(jixiao) jixiao,
CONVERT(varchar(7), FeeTime, 120) as FeeTime FROM serV_Employee_JournalItem j join bpms_organization o on o.code=j.departcode
WHERE departcode is not null AND year(feeTime)='2016' and month(feetime)='02' and workkind in('医疗','医技')
and clinicitemclass in (2,4) AND OrganizationId IN('31b05701-60ef-405c-87ba-af47049e3f48','297cd29a-fb66-42fb-9ba0-bad60fc8144d',
'21e34fa7-e4b2-4aa7-8c44-b38302c9138b','01bddbb4-df03-40c6-82fa-89ed93852d5f','e4ecb3a2-b59a-46fd-b300-0dddb3f7d1bc'............)
group by CONVERT(varchar(7), FeeTime, 120)
union all
SELECT Departcode,departname,EmployCode='',realname='科室总计',sum(expenses) expenses,sum(jixiao) jixiao,
CONVERT(varchar(7), FeeTime, 120) as FeeTime FROM serV_Employee_JournalItem j join bpms_organization o on o.code=j.departcode
WHERE departcode is not null AND year(feeTime)='2016' and month(feetime)='02' and workkind in('医疗','医技') and
clinicitemclass in (2,4) AND OrganizationId IN('31b05701-60ef-405c-87ba-af47049e3f48','297cd29a-fb66-42fb-9ba0-bad60fc8144d',
'21e34fa7-e4b2-4aa7-8c44-b38302c9138b','01bddbb4-df03-40c6-82fa-89ed93852d5f','e4ecb3a2-b59a-46fd-b300-0dddb3f7d1bc'............)
group by Departcode, departname,CONVERT(varchar(7), FeeTime, 120)