set dateformat dmy
declare @DateBegin date = '01.11.2014', @DateEnd date = '30.11.2014'

select top 1 count(*) over()
from MSP_EpmResourceByDay
where TimeByDay between @DateBegin and @DateEnd
group by TimeByDay having sum(basecapacity)>0

-- Количество рабочих дней у человека
select r.ResourceUID, r.ResourceName, count(*) [cntWD]
from MSP_EpmResourceByDay b
inner join MSP_EpmResource r on b.ResourceUID = r.ResourceUID
where TimeByDay between @DateBegin and @DateEnd and BaseCapacity > 0
group by r.ResourceUID, r.ResourceName

-- Емкость
select r.ResourceUID [Res_UID], r.ResourceName [Res_Name], sum(b.capacity) [Capacity]
from MSP_EpmResourceByDay b 
inner join MSP_EpmResource r on b.ResourceUID = r.ResourceUID
where r.ResourceIsActive = 1 and ResourceType = 2 -- обычные люди, не универсальные ресурсы. Универсальный ресурс ResourceType = 20
and TimeByDay >= @DateBegin and TimeByDay < dateadd(dd,1,@DateEnd)
group by r.ResourceUID, r.ResourceName