declare @imax INT,
		@i INT
	SET @imax = 400 -- change to max value
    SET @i = 1 
    
while (@i <= @imax)
	Begin
	Insert into Workflow_status 
	(WF_date)values (convert(date, getdate() + @i,101))
	SET @i = @i + 1 
	
END

This loop adds a bunch of records to your database with a date field pre-populated. Works well for pre-populating a table for filling out daily by a form

Add dated records to MSSQL using while loop

SQL