clintz
try this..
declare @tbl table (empID int, name varchar(5))
insert into @tbl
select 2, 'a' union all
select 21, 'b' union all
select 33, 'c' union all
select 10, 'd' union all
select 13, 'e' union all
select 18, 'f' union all
select 5, 'g'
declare @i int
set @i = 0
declare @t table (RandomEmpID int)
declare @rand int
while @i < 100
begin
select @rand = floor(rand() * 1000)
if (@rand not in (select empID from @tbl))
begin
insert into @t
select @rand
set @i = @i+1
end
end
select * from @t
if you don't want random numbers, you can just increment your max(empID) upto 100..
- clintz