/****** Сценарий для команды SelectTopNRows среды SSMS  ******/
declare @t table ([UniqueID] int, d datetime,c int)

set dateformat dmy
insert into @t

SELECT [UniqueID],CONVERT(varchar(20),TimeNav,102),COUNT(*)
  from  
        
[SPECTRANS].[dbo].[Nav]
inner join [SPECTRANS].dbo.tbRadioTransportLink on NSIT_UniqueID=[UniqueID]

where TimeNav between '09/03/2012' and '10/03/2012'
group by [UniqueID],CONVERT(varchar(20),TimeNav,102)

select rs.NSIR_StationNum,t.c,t.d from @t as t
inner join [SPECTRANS].dbo.tbRadioTransportLink as TL on NSIT_UniqueID=[UniqueID]
inner join [SPECTRANS].dbo.tbNSIRadioStations as RS on RS.NSIR_StationNum=TL.NSIR_StationNum