DECLARE @startDate DATETIME ='2020-12-09T00:00:00',  @endDate DATETIME ='2020-12-09T23:59:59'

SELECT NEWID() AS Id
	    ,CONVERT(INT, f.FullNameFloor) AS PartnerId
	    ,s.TimeRecord AS DateReport
	    ,s.ID_Sensor AS CameraId
	    ,s.SumIn AS CounterIn
	    ,s.SumOut AS CounterOut
FROM PCOUNT.Read_City_Count_523.dbo.CM_StorageSensor AS s
INNER JOIN PCOUNT.Read_City_Count_523.dbo.CM_Controller AS c
    ON s.ID_Controller = c.ID_Controller
INNER JOIN PCOUNT.Read_City_Count_523.dbo.CM_Floor AS f
   ON c.ID_Floor = f.ID_Floor
WHERE ISNUMERIC(f.FullNameFloor) = 1 
	   AND s.TimeRecord BETWEEN @startDate AND @endDate

 DECLARE @startDate DATETIME ='2020-12-09T00:00:00',  @endDate DATETIME ='2020-12-09T23:59:59',
                        @commandString nvarchar(1000) ='SELECT
		   NEWID() AS Id
		   ,CONVERT(INT, f.FullNameFloor) AS PartnerId
		   ,s.TimeRecord AS DateReport
		   ,s.ID_Sensor AS CameraId
		   ,s.SumIn AS CounterIn
		   ,s.SumOut AS CounterOut
		FROM PCOUNT.Read_City_Count_523.dbo.CM_StorageSensor AS s
		INNER JOIN PCOUNT.Read_City_Count_523.dbo.CM_Controller AS c
			ON s.ID_Controller = c.ID_Controller
		INNER JOIN PCOUNT.Read_City_Count_523.dbo.CM_Floor AS f
			ON c.ID_Floor = f.ID_Floor
		WHERE ISNUMERIC(f.FullNameFloor) = 1 
		      AND s.TimeRecord BETWEEN @startDate AND @endDate'

  EXEC sys.sp_executesql @commandString,N'@startDate DATETIME, @endDate DATETIME', @startDate, @endDate