declare @feIni datetime ='2022-02-21'
declare @fefin datetime ='2022-03-21'
CREATE TABLE #TablaTemporal (FECHA DATE);
WHILE(@feIni<@fefin)
BEGIN
INSERT INTO #TablaTemporal
SELECT @feIni
SET @feIni = DATEADD(DD,1,@feIni)
END
select * from #TablaTemporal