Changing Dates

[glewis1636]

I have a table with a date column. I would like to randomly update those dates that fall within a certain range to a new date within another range...

for example, all dates that fall before 8/1/05 changed to some date in the range 11/15/05 to 11/15/06.

Any ideas?

 

[rac2]

DECLARE @seed INT
SET @seed = 7
UPDATE MyTable SET
   col_dates = DATEADD(day, FLOOR(RAND(@seed)*365), '11/15/05')
WHERE DATEDIFF(day, col_dates, '8/15/05') > 0