;with cte as
(
select cast('2012-01-01' as datetime) date
union all
select dateadd(day,1,cte.date) from cte where year(dateadd(day,1,cte.date))=2012
)
select * from cte
left j……
[/Quote]
;with cte as
(
select cast('2012-01-01' as datetime) date
union all
select dateadd(day,1,cte.date) from cte where year(dateadd(day,1,cte.date))=2012
)
select * from cte
left join ......
option (maxrecursion 1000)