This will be your solution
CREATE Table #Temp2(TagId varchar(5),Antenna INT,DT varchar(30))
SELECT * INTO #Temp from
(
Select 'Q11' as TagID,1 as Antenna,'07/23/2014 11:10:01 pm' as DT
UNION
Select 'Q11' as TagID,1 as Antenna,'07/23/2014 11:10:02 pm' as DT
UNION
Select 'Q11' as TagID,1 as Antenna,'07/23/2014 11:10:03 pm' as DT
UNION
Select 'Q11' as TagID,1 as Antenna,'07/23/2014 11:10:04 pm' as DT
UNION
Select 'Q11' as TagID,1 as Antenna,'07/23/2014 11:10:05 pm' as DT
UNION
Select 'Q11' as TagID,1 as Antenna,'07/23/2014 11:10:06 pm' as DT
UNION
Select 'Q11' as TagID,1 as Antenna,'07/23/2014 11:10:07 pm' as DT
UNION
Select 'Q11' as TagID,1 as Antenna,'07/23/2014 11:10:08 pm' as DT
UNION
Select 'Q22' as TagID,2 as Antenna,'07/23/2014 11:10:09 pm' as DT
UNION
Select 'Q22' as TagID,2 as Antenna,'07/23/2014 11:10:10 pm' as DT
UNION
Select 'Q22' as TagID,2 as Antenna,'07/23/2014 11:10:11 pm' as DT
UNION
Select 'Q22' as TagID,2 as Antenna,'07/23/2014 11:10:12 pm' as DT
UNION
Select 'Q22' as TagID,2 as Antenna,'07/23/2014 11:10:13 pm' as DT
) as A
Declare @i INT = 0
DECLARE @T as DateTime
SELECT @T = min(DT) FROM #TEMP (NOLOCK)
WHILE @i < (select count(*) FROM #Temp (NOLOCK))
BEGIN
INSERT INTO #Temp2
Select * FROM #Temp (NOLOCK) Where cast(DT as DATETIME) = @T
SET @i = @i+1
SET @T = dateadd(ss,5,@T)
END
SELECT * FROM #Temp2
Drop TABLE #Temp2
Drop TABLE #Temp