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