123213, Sql Server

Language: Layout:

-- Create Temp Table
CREATE TABLE #Overlap

(
TableId int IDENTITY(1,1),
SubType varchar(50), 
Cause varchar(9),
CircuitID varchar(100),
BegDate date,
EndDate date,
AmtSought decimal(11,2),
Remarks varchar(max))

--Insert records

INSERT INTO #Overlap VALUES('Original','201500018','36/KQ--/831670/IP /NUVX/','2016-12-01','2016-12-31',354.41,'Rec 1')
INSERT INTO #Overlap VALUES('Original','201500009','36/VCID/826061/IP/NUVX','2016-08-11','2016-08-12',200.50,'Rec 2')
INSERT INTO #Overlap VALUES('Original','201500018','36/KQ--/831670/IP /NUVX/','2016-11-15','2016-12-14',100.25,'Rec 3')
INSERT INTO #Overlap VALUES('Original','201500018','36/KQ--/831670/IP /NUVX/','2016-12-16','2017-01-15',300.75,'Rec 4')
INSERT INTO #Overlap VALUES('Original','201500018','36/KQ--/831670/IP /NUVX/','2017-01-01','2017-01-01',500.00,'Rec 5')
INSERT INTO #Overlap VALUES('Original','201500009','36/VCID/826061/IP/NUVX','2016-07-01','2016-07-31',100.50,'Rec 6')

SELECT * FROM #Overlap o
WHERE EXISTS
(
	SELECT 1 FROM #Overlap o2
	WHERE o2.SubType = o.SubType
	AND o2.Cause = o.Cause
	AND o2.CircuitID = o.CircuitID
	AND (
			o2.BegDate BETWEEN o.BegDate AND o.EndDate
			OR o2.EndDate BETWEEN o.BegDate AND o.EndDate
			OR o.BegDate BETWEEN o2.BegDate AND o2.EndDate
			OR o.EndDate BETWEEN o2.BegDate AND o2.EndDate
		)
	AND o2.TableId != o.TableId
)
ORDER BY o.SubType, o.Cause, o.BegDate

DROP TABLE #Overlap

View schema
Execution time: 0,03 sec, rows selected: 4, rows affected: 6, absolute service time: 0,19 sec