怎么让查询结果出现多次

[jishengzu]

比如
select getdate()

这样查询出来的结果是一行

我要让它变为12行 该怎么做。

[pt1314917]

select a.* from (select dt=getdate())a full join
(select a=1 union all select 2 union all select 3
union all select 4
union all select 5
union all select 6
union all select 7
union all select 8
union all select 9
union all select 10
union all select 11
union all select 12)b
on 1=1

[jishengzu]

就是用于查询住户12个月的租金情况
其他有某个月未登记租金，
如果用用户表join租金表的话就少了某个月的记录。

[SQL77]

SELECT 
	NUMBER,
	GETDATE() TIME
FROM 
	MASTER..SPT_VALUES 

WHERE TYPE='P' 

AND NUMBER BETWEEN 1 AND 12

NUMBER      TIME                                                   
----------- ------------------------------------------------------ 
1           2010-01-10 14:14:13.390
2           2010-01-10 14:14:13.390
3           2010-01-10 14:14:13.390
4           2010-01-10 14:14:13.390
5           2010-01-10 14:14:13.390
6           2010-01-10 14:14:13.390
7           2010-01-10 14:14:13.390
8           2010-01-10 14:14:13.390
9           2010-01-10 14:14:13.390
10          2010-01-10 14:14:13.390
11          2010-01-10 14:14:13.390
12          2010-01-10 14:14:13.390

（所影响的行数为 12 行）

[SQL77]

SELECT 
	DATEADD(MM,NUMBER,'2009-01-01')
	
FROM 
	MASTER..SPT_VALUES 

WHERE TYPE='P' 

AND DATEADD(MM,NUMBER,'2009-01-01')<='2009-12-01'

                                                       
------------------------------------------------------ 
2009-01-01 00:00:00.000
2009-02-01 00:00:00.000
2009-03-01 00:00:00.000
2009-04-01 00:00:00.000
2009-05-01 00:00:00.000
2009-06-01 00:00:00.000
2009-07-01 00:00:00.000
2009-08-01 00:00:00.000
2009-09-01 00:00:00.000
2009-10-01 00:00:00.000
2009-11-01 00:00:00.000
2009-12-01 00:00:00.000

（所影响的行数为 12 行）

产生缺失月份