- [CreatedDateTime] >= '2018-02-19 00:00' and [CreatedDateTime] <= '2018-02-20 00:00'
 
- SELECT *
 
-   FROM [iBems].[dbo].[BemsMonitoringPointHistoryDaily]
 
-   where [SiteId] =1 and  [CreatedDateTime]>= '2018-02-19 00:00' and [CreatedDateTime] <= '2018-02-20 00:00'
 
-   delete [iBems].[dbo].[BemsMonitoringPointHistoryDaily]
 
-   where [SiteId] =1 and  [CreatedDateTime]>= '2018-02-19 00:00' and [CreatedDateTime] <= '2018-02-20 00:00'
 
 
  |