Pasted

SELECT ones.n + 10*tens.n + 100*hundreds.n + 1000*thousands.n
FROM
           (VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9)) ones(n)
INNER JOIN (VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9)) tens(n) ON 1=1
INNER JOIN (VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9)) hundreds(n) ON 1=1
INNER JOIN (VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9)) thousands(n) ON 1=1
ORDER BY 1