In their most recent webinar, Skyport Systems explores ways to isolate and protect critical databases to keep the core of your company safe from harm.
select count(cl.CASE_NUM), svc.SUB_UNIT_ID, unit.[DESC] from svc inner join cl on cl.ID = svc.CLIENT_ID inner join unit on unit.ID = svc.SUB_UNIT_ID where svc.BEG_DATE >= '2011-07-01' and svc.BEG_DATE <= '2012-06-30' and svc.SVC_ID < 900 and unit.ACTIVE_FLAG = 'Y' and cl <> 0 group by svc.SUB_UNIT_ID, unit.[DESC] order by svc.SUB_UNIT_ID
Join the community of 500,000 technology professionals and ask your questions.