By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE #TableA(
RID int NULL,
StartPos int NULL,
EndPos int NULL
)
INSERT #TableA (RID, StartPos, EndPos) VALUES (7, 45, 77)
INSERT #TableA (RID, StartPos, EndPos) VALUES (7, 118, 130)
INSERT #TableA (RID, StartPos, EndPos) VALUES (7, 197, 212)
INSERT #TableA (RID, StartPos, EndPos) VALUES (7, 218, 235)
CREATE TABLE #TableB(
RID int NULL,
StartPos int NULL,
EndPos int NULL
)
INSERT #TableB (RID, StartPos, EndPos) VALUES (7, 83, 87)
INSERT #TableB (RID, StartPos, EndPos) VALUES (7, 121, 132)
INSERT #TableB (RID, StartPos, EndPos) VALUES (7, 175, 179)
INSERT #TableB (RID, StartPos, EndPos) VALUES (7, 183, 191)
INSERT #TableB (RID, StartPos, EndPos) VALUES (7, 195, 214)
INSERT #TableB (RID, StartPos, EndPos) VALUES (7, 221, 237)
SELECT *
FROM #TableA
SELECT *
FROM #TableB
| RID | StartPos | EndPos |
|---|---|---|
| 7 | 45 | 77 |
| 7 | 118 | 130 |
| 7 | 197 | 212 |
| 7 | 218 | 235 |
| RID | StartPos | EndPos |
|---|---|---|
| 7 | 83 | 87 |
| 7 | 121 | 132 |
| 7 | 175 | 179 |
| 7 | 183 | 191 |
| 7 | 195 | 214 |
| 7 | 221 | 237 |
select * from #TableB b
where not exists (
select 1 from #TableA a
where b.StartPos between a.StartPos and a.EndPos
)
union
select * from #TableA a
where not exists (
select 1 from #TableB b
where a.StartPos between b.StartPos and b.EndPos
and a.EndPos between b.StartPos and b.EndPos
)
;
| RID | StartPos | EndPos |
|---|---|---|
| 7 | 45 | 77 |
| 7 | 83 | 87 |
| 7 | 118 | 130 |
| 7 | 175 | 179 |
| 7 | 183 | 191 |
| 7 | 195 | 214 |
| 7 | 218 | 235 |