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