是想要下面的结果吗?我刚回答过别人的一个类似问题
SELECT MONTH_VALUE FROM
(
SELECT 1 AS MONTH_VALUE
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
) T
WHERE MONTH_VALUE > = datepart(mm,'2007-10-24')
AND MONTH_VALUE <= datepart(mm,'2007-12-24')