Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.
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
|MSSQL: Query to convert field in a row into several rows||29||43|
|Why do I get extra rows when I do inner join?||12||29|
|SQL Server 2008 Error||7||33|
|SSD vs SAS disk for SQL||3||9|
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
18 Experts available now in Live!