declare @start int , @end int;
set @start = -10; set @end = 10;

/* -- for Version 2008
declare @start int = -10, @end int = 10;
*/

select top (@end-@start+1) (row_number() over(order by (select null)))-1+@start as nn
from sys.system_columns t1
cross join sys.system_columns t2
cross join sys.system_columns t3;

WITH
s as
    (
    SELECT N FROM
    (
    SELECT 1a,2b,3c,4d,5z,6f,7g,8h,9i,10j
    )E
    UNPIVOT(N FOR x IN(a,b,c,d,z,f,g,h,i,j))u
    )
, p as
    (
    select r=ROW_NUMBER()over(order by (select 1)) from s a1,s a2,s a3,s a4,s a5, s a6
    )
    select r from p;

WITH Digits
AS
(
SELECT d FROM (VALUES (0),(1),(2),(3),(4),(5),(6),(7),(8),(9)) AS d(d)
)
SELECT     (((100000 * ht.d + 10000 * tt.d) + 1000 * st.d) + 100 * h.d) + 10 * t.d + s.d + 1 AS n
FROM         Digits AS s CROSS JOIN
                      Digits AS t CROSS JOIN
                      Digits AS h CROSS JOIN
                      Digits AS st CROSS JOIN
                      Digits AS tt CROSS JOIN
                      Digits AS ht
ORDER BY n