SQLServerMASTER..spt

--0~2047 共2048個數(shù)字
SELECT number FROM MASTER..spt_values WHERE TYPE = 'p'

SELECT CONVERT(CHAR(10), DATEADD(DAY, number, GETDATE()), 120) AS [日期]
FROM MASTER..spt_values WHERE TYPE='P' AND number>0

--將一個數(shù)值以 1 來均分成多個等份，不足的顯示小數(shù)
;WITH cte(past) AS(
 SELECT 2.2
 )
SELECT number,
 (
 CASE 
 WHEN past >= number THEN 1.0 --當(dāng)原小數(shù)值>當(dāng)前行值顯示 1.0
 ELSE past -FLOOR(past)	 --否則顯示為小數(shù)值
 END
 ) AS result
FROM cte,
 MASTER..spt_values
WHERE 
	 1=1
	 AND CEILING(past) >= number	--原小數(shù)值向上取大 >= number
 AND TYPE = 'P'
 AND number > 0
/*
number result
----------- ---------------------------------------
1 1.0
2 1.0
3 0.2
*/