CREATE TABLE #PeriodTMP
	(
	PeriodID int NOT NULL IDENTITY ( 1 ,  1 ),
	[Date] datetime NOT NULL
	)

DECLARE @DateStart DateTime
DECLARE @DateEND DateTime
SET @DateStart = Convert(datetime,'19960101', 112 );
SET @DateEND = Convert(datetime,'20101231', 112 )
While @DateStart <= @DateEND 
BEGIN
	IF DatePart(yy,@DateStart)% 4  =  0 
	INSERT INTO #PeriodTMP ([Date])
	select top  366  dateadd(dd, -Day(@DateStart), dateadd(mm,-Month(@DateStart)+ 1 ,@DateStart)) +(select count(*) from master..sysobjects where id<=a.id) AS [Date] 
	from master..sysobjects a Order by [Date]
	ELSE
	INSERT INTO #PeriodTMP ([Date])
	select top  365  dateadd(dd, -Day(@DateStart), dateadd(mm,-Month(@DateStart)+ 1 ,@DateStart)) +(select count(*) from master..sysobjects where id<=a.id) AS [Date] 
	from master..sysobjects a Order by [Date]
	
	SELECT @DateStart = dateadd(yy, 1 ,@DateStart)

END