create table N (i int not null identity(100,1) constraint PK_ primary key,test bit);create table #tmp (i int not null primary key);GO-- run these 2 inserts 3 timesinsert into dbo.N (test) OUTPUT INSERTED.i INTO #tmp (i) values (1),(1),(1) ;insert into dbo.N (test) OUTPUT INSERTED.i INTO #tmp (i) SELECT test FROM (values (1),(1),(1)) AS n(test) ;Goselect * from #tmpGO-- clean updrop table Ndrop table #tmpGO