declare @start datetime
declare @stop datetime
select @start ='01.06.2011', @stop='01.07.2011'
SELECT D.DevNum
       ,O.DefaultName
       ,o.TechComment
       ,AD.Describtion
       ,sum([MsgWithGPS]) as c_ok
       ,sum([MsgWithoutGPS]) as c_nogps
   FROM [BNComplex].dbo.Devices as D  
   left join [BNComplex].[dbo].[BillingData] as BD on D.DeviceID=BD.DeviceID and [BillingDayDate] between @start and @stop
   left join [BNComplex].dbo.AreaDescr as AD on AD.AreaID=D.AreaID
   left join [BNComplex].dbo.DevicesOnObjects as DOO on DOO.DeviceID=D.DeviceID
   left join [BNComplex].dbo.Objects as O on o.ObjectID=DOO.ObjectID
   --where [BillingDayDate] between '01.06.2011' and '01.07.2011'
   group by  D.DevNum
       ,O.DefaultName
       ,o.TechComment
       ,AD.Describtion
   order by AD.Describtion,O.DefaultName
    
GO