whitout table, you can use

DECLARE @FEC_INI DATETIME, @FEC_FIN DATETIME

SELECT @FEC_INI = '01/01/1900', @FEC_FIN = '31/12/2010';

WITH DIAS AS

(

SELECT @FEC_INI AS FEC

UNION ALL

...