aaaa

alter table report.test add CommitedFlag bit default 0;


--TAB 1

insert into report.test (lol) values ('long tx')



WAITFOR DELAY '00:00:10';


update report.test set CommitedFlag = 1 where lol = 'long tx';

--TAB 2


insert into report.test (lol) values ('short tx')

update report.test set CommitedFlag = 1 where lol = 'short tx';


--TAB 3
select *
from report.test
where id > 2000
  and id < (select min(id) from report.test where CommitedFlag = 0);