CREATE Function [compliance].join compliance.tbl_Activity on compliance.tbl_Users.UnitID=compliance.tbl_Activity.UnitID
where @ActivityID=compliance.tbl_Activity.ActivityID and compliance.tbl_Users.Active=1 and compliance.tbl_Users.Windo
select ScheduleClause, when 1 then 1 end) Compliance, when 0 then 1 end) NonCompliance
from Compliance_RiskRegisterEntry crwhere cr.RiskRegisterTypeId = 1 and Auditor = 5508 and MONTH(Au