Data extrapolation on the fly

CREATE TABLE #temp
(
myName VARCHAR (10),
StartDate DateTime
)
GO

INSERT INTO #temp VALUES ('Mohit', '2008-09-15')
INSERT INTO #temp VALUES ('Nayyar', '2008-09-22')
GO

WITH First2 (seq) AS
(
SELECT 1 UNION ALL SELECT 1
)
, First4 (seq) AS
(
SELECT 1 FROM First2 x CROSS JOIN First2 y
)
, First16 (seq) AS
(
SELECT 1 FROM First4 x CROSS JOIN First4 y
)
, First256 (seq) AS
(
SELECT 1 FROM First16 x CROSS JOIN First16 y
)
, First65536 (seq) AS
(
SELECT 1 FROM First256 x CROSS JOIN First256 y
)
, SeqRows AS
(
SELECT ROW_NUMBER () OVER (Order by Seq) AS SeqNumber
FROM First65536 WITH (NOEXPAND)
)

SELECT myName, StartDate, 
DATEADD(DAY, n.SeqNumber-1, StartDate) AS Extrapolation
FROM #temp
CROSS JOIN SeqRows n
WHERE n.SeqNumber <= DATEDIFF(DAY, StartDate, GETDATE())
ORDER BY myName, StartDate, 3
GO

DROP TABLE #temp
GO