create table #t (i int) insert #t select 1 union select 2 union select 3 ... union select 9select b.* from #t b left join A on b.i=a.b where a.b is nulldrop table #t
declare @maxid int,@sql nvarchar(4000) SELECT @maxid=MAX(B) FROM A SET @sql='SELECT TOP '+CAST(@maxid AS varchar) +' IDENTITY(int,1,1) id INTO ##tem FROM sysobjects a,sysobjects b,sysobjects c' EXEC sp_executesql @sqlSELECT id FROM ##tem WHERE id not in (SELECT B FROM A) DROP TABLE ##tem
SELECT @maxid=MAX(B) FROM A
SET @sql='SELECT TOP '+CAST(@maxid AS varchar)
+' IDENTITY(int,1,1) id INTO ##tem FROM sysobjects a,sysobjects b,sysobjects c'
EXEC sp_executesql @sqlSELECT id FROM ##tem WHERE id not in (SELECT B FROM A)
DROP TABLE ##tem