Thank you,

But I do not mean publishing number table, I mean Splitting method is not simpler?

Also, A simplified method for publishing number table (no loop, no recursion, and no ranking)

;WITH C (i) AS

(SELECT '0' UNION SELECT '1' UNION SELECT '2' UNION SELECT '3' UNION SELECT '4' UNION SELECT '5'

UNION SELECT '6' UNION SELECT '7' UNION SELECT '8' UNION SELECT '9')

SELECT c1.i + c2.i + c3.i + c4.i + 1 AS nbr --10000 numbers

FROM C c1, C c2, C c3, C c4