/****** Скрипт для команды SelectTopNRows из среды SSMS  ******/
SELECT TOP 1000 d.time, d.value, [CP_ST-FuelCalculation].[Util]. [GetTareValue](s.EntityId,d.Value) Литры
,s.name, s.number, O.GarageNumber
  FROM [CP_ST-TelematicsAnalog].[dbo]. [Data]as D
  inner join 
  [CP_ST-BusinessEntity].[Data]. [Sensor]as S on S.EntityId=D.SensorId
  inner join [CP_ST-BusinessEntity].[Data]. [Terminal]as T  on T.[EntityId]=S.TerminalId
  left join [CP_ST-BusinessEntity].[Data]. [Vehicle]as O on O.EntityId=T.MonObjId
  where o.GarageNumber = 'н850та' and S.SensorTemplateId=31 and s.number=11
  and d.time between '07/07/2017' and '08/07/2017'