통계용 달력 쿼리 만들기

통계 조인을 위해 2년(2007~2008 )정도 년-월-일 (yyyy-mm-dd) 이 들어간 테이블

MS-SQL 2005

Select convert(char(10),dateadd(d,number,'2007-01-01'),120) dt

From master..spt_values

Where Type = 'P'

And number <= datediff(d,'2007-01-01','2008-12-31')

MS-SQL 2000

declare @CopyT table (n int primary key)

insert @CopyT

select a.n+b.n+c.n

from (select top 10 str(number,1) n from master..spt_values where type ='P') a,

(select top 10 str(number,1) n from master..spt_values where type ='P') b,

(select top 10 str(number,1) n from master..spt_values where type ='P') c

select convert(char(10),dateadd(d,n,'2007-01-01'),120) dt

from @CopyT

where n <= datediff(d,'2007-01-01','2008-12-31')

카푸네집