Hi SUJAYS,
As per your query i have create the sample.If you have any doubt please revert me back.Below is the given sample.
SQL
DECLARE @DATES TABLE
(Dates DATETIME)
INSERT INTO @DATES VALUES('07-01-2017')
INSERT INTO @DATES VALUES('07-02-2017')
INSERT INTO @DATES VALUES('07-03-2017')
INSERT INTO @DATES VALUES('07-04-2017')
INSERT INTO @DATES VALUES('07-05-2017')
INSERT INTO @DATES VALUES('07-17-2017')
INSERT INTO @DATES VALUES('07-14-2017')
INSERT INTO @DATES VALUES('07-20-2017')
INSERT INTO @DATES VALUES('07-25-2017')
UPDATE @DATES
SET Dates ='07-20-2017'
WHERE Dates BETWEEN '07-01-2017' AND '07-10-2017'
Output
| Dates |
| 7/20/2017 0:00 |
| 7/20/2017 0:00 |
| 7/20/2017 0:00 |
| 7/20/2017 0:00 |
| 7/20/2017 0:00 |
| 7/17/2017 0:00 |
| 7/14/2017 0:00 |
| 7/20/2017 0:00 |
| 7/25/2017 0:00 |
