xMmChqAz

1declare @min int
2declare @max int
3
4select @min = min(seq_field), @max = max(seq_field) from [Table]
5
6create table #tmp (Field_No int)
7while @min <= @max
8begin
9   if not exists (select * from [Table] where seq_field = @min)
10      insert into #tmp (Field_No) values (@min)
11   set @min = @min + 1
12end
13select * from #tmp