用这个代码可以生成指定日期之间的年月DECLARE @startdate DATETIME , @enddate DATETIME SET @startdate = '2008-01-01' SET @enddate = '2009-12-31' SELECT DISTINCT YEAR(CONVERT(VARCHAR(10), DATEADD(day, number, @startdate), 120)) AS [year] , MONTH(CONVERT(VARCHAR(10), DATEADD(day, number, @startdate), 120)) AS [month] FROM master..spt_values WHERE DATEDIFF(day, DATEADD(day, number, @startdate), @enddate) >= 0 AND number >= 0 AND type = 'p'
@enddate DATETIME
SET @startdate = '2008-01-01'
SET @enddate = '2009-12-31'
SELECT
DISTINCT
YEAR(CONVERT(VARCHAR(10), DATEADD(day, number, @startdate), 120)) AS [year] ,
MONTH(CONVERT(VARCHAR(10), DATEADD(day, number, @startdate), 120)) AS [month]
FROM master..spt_values
WHERE DATEDIFF(day, DATEADD(day, number, @startdate), @enddate) >= 0
AND number >= 0
AND type = 'p'
DECLARE @startdate DATETIME ,
@enddate DATETIME
SET @startdate = '2000-01-01'
SET @enddate = '2014-12-31' --最多只能产生 2005 8
SELECT
DISTINCT
YEAR(CONVERT(VARCHAR(10), DATEADD(day, number, @startdate), 120)) AS [year] ,
MONTH(CONVERT(VARCHAR(10), DATEADD(day, number, @startdate), 120)) AS [month]
FROM master..spt_values
WHERE DATEDIFF(day, DATEADD(day, number, @startdate), @enddate) >= 0
AND number >= 0
AND type = 'p'
比如现在我有一个with的递归,给他一个参数A,他就能得一些数据集,
现在我有三个参数,A,B,C
我想将这三个参数得出的数据集结果合并返回,如何做?