create table #test
(i int, a varchar( 20 ))
go
insert into #test (i,a)
select  1 ,'a'
union all
select  2 ,'b'
union all
select  3 ,'c'
union all
select  4 ,'d'
union all
select  5 ,'e'
go
select * from #test
go

i           a                    
----------- -                    
          1 a                    
          2 b                    
          3 c                    
          4 d                    
          5 e