set dateformat dmy
use bncomplex
select convert (varchar(7),navtime,120) mes,count(*) count from [dbo]. [ObjectsMotions]with (nolock)
where navtime<'01/02/2014' -- фильтр для данных не раньше  
group by convert (varchar(7),navtime,120)
order by convert (varchar(7),navtime,120)