create table tb(a varchar(10),b int)
insert tb select 1234567 ,20
union all select 2345678 ,30
union all select 3456789 , 10
union all select 1111111, 100
select top 100 identity(int) id into # from sysobjects,syscolumns
select a.* from tb a
inner join # b
on a.b>=b.id
drop table tb,#