| [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'
 |