Numbers from 0 to 9999.

Numbers.sql

WITH [Numbers] AS
(
    SELECT
        [Ones].[Number] +
        10 * [Tens].[Number] +
        100 * [Hundreds].[Number] +
        1000 * [Thousands].[Number]
        AS [Number]
    FROM (VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9)) [Ones]([Number]),
         (VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9)) [Tens]([Number]),
         (VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9)) [Hundreds]([Number]),
         (VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9)) [Thousands]([Number])
)
SELECT * FROM [Numbers] ORDER BY 1;