Select a + b * 10 + 1 From (Select 0 As a 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) A, (Select 0 As b 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) B Order By a + b * 10 + 1
select top 100 id=identity(int,1,1) into #t from sysobjects,syscolumnsselect id from #tdrop table #t
select top 100 id=identity(int ,1,1) into # from sysobjects A, sysobjects bdeclare @str varchar(1000) set @str='''' select @str=@str+cast(id as varchar)+'''' from #
a + b * 10 + 1
From
(Select 0 As a
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) A,
(Select 0 As b
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) B
Order By
a + b * 10 + 1
set @str=''''
select @str=@str+cast(id as varchar)+'''' from #