公式是不是给错了？？假设应出勤100，实出勤80 那100/80 岂不是出勤率很高

SELECT B.个数/A.个数*1.0 FROM(

SELECT d.depart_name,count(a.emp_id) as 个数

FROM  employee a

left join (select  case ctype when '0' then '固定期限' when '1' then '无固定期限' else '其他' end as 合同类别,* from contact) b on a.emp_id=b.emp_id and b.status=1 

left join Degrees c on a.edu_id=c.degree_id 

left join Departs d  on left(a.depart_id,7)=d.depart_id

where work_status=1 AND LEFT(a.depart_id,7)='0080101' AND a.depart_id<>'0080101'

group by d.depart_name

) A INNER JOIN (

——实出勤人数

SELECT c.depart_name,count(DISTINCT a.emp_id) as 个数

FROM dbo.TimeRecords a

INNER JOIN dbo.employeeinfo b ON a.emp_id=b.emp_id

INNER JOIN dbo.Departs c ON LEFT(b.depart_id, 9)=c.depart_id

WHERE CONVERT(VARCHAR(10), a.sign_time, 120)=CONVERT(VARCHAR(10), GETDATE(), 120)

AND LEFT(b.depart_id,7)='0080101' AND b.depart_id<>'0080101'

GROUP BY c.depart_name

) B ON A.depart_name=B.depart_name

select depart_name,sum(应出勤人数) / sum(实出勤人数) as 出勤率 (

SELECT d.depart_name,count(a.emp_id) as 应出勤人数, 0 实出勤人数

FROM  employee a

left join (select  case ctype when '0' then '固定期限' when '1' then '无固定期限' else '其他' end as 合同类别,* from contact) b on a.emp_id=b.emp_id and b.status=1 

left join Degrees c on a.edu_id=c.degree_id 

left join Departs d  on left(a.depart_id,7)=d.depart_id

where work_status=1 AND LEFT(a.depart_id,7)='0080101' AND a.depart_id<>'0080101'

group by d.depart_name

union all

SELECT c.depart_name,0 应出勤人数,count(DISTINCT a.emp_id) as 实出勤人数

FROM dbo.TimeRecords a

INNER JOIN dbo.employeeinfo b ON a.emp_id=b.emp_id

INNER JOIN dbo.Departs c ON LEFT(b.depart_id, 9)=c.depart_id

WHERE CONVERT(VARCHAR(10), a.sign_time, 120)=CONVERT(VARCHAR(10), GETDATE(), 120)

AND LEFT(b.depart_id,7)='0080101' AND b.depart_id<>'0080101'

GROUP BY c.depart_name

) a

group by depart_name