CREATE NONCLUSTERED INDEX [ANVIZ_T_Protocol_Time] ON [dbo].[T_Protocol]
(
	[time] ASC
)
INCLUDE ( 	[objid],
	[param1],
	[objtype]) WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO

SELECT Office,
       Time,
	   UserName,
	   Direction,
	   SensorID,
	   nextTime,
	   DATEDIFF(ss, Time, nextTime) AS sec
  FROM (SELECT Office,
               Time,
			   UserName,
			   Direction,
			   SensorID,
			   (SELECT TOP (1) Time
				  FROM dbo.V_ShortUnionData AS t2
                 WHERE (Time > t1.Time)
				   AND (t2.Office = N'Л')
				   AND (t1.UserName = UserName)
				   AND (t1.Direction = Direction)
				   AND (t1.SensorID = SensorID)
				 ORDER BY t1.Time) AS nextTime
          FROM dbo.V_ShortUnionData AS t1) AS t
  WHERE (DATEDIFF(ss, Time, nextTime) <= 10)