Database

SELECT * FROM schedule_intervals WHERE schedule_id IN (SELECT _id FROM service_schedules WHERE vehicle_id = 4) AND (163451 < mileage OR 1621540799076 < date)

Hello everyone .
I have an accounting calculation problem. I want to write it with SQL Query (in ssms).
I have two groups of documents related to one person (creditor and debtor)
Creditor documents cover debtor documents.
Consider the following example: (How can the result be achieved?) 

USE [master]
GO

DROP TABLE IF EXISTS #credit/*creditor=0*/,#debit/*Debtor=1*/

SELECT *
INTO #debit
FROM 	(values 
		(88,'2/14',1,5,1),(88,'2/15',2,5,1)
		)A (personID,DocDate,DocID,Fee,IsDebit)

SELECT *
INTO #credit
FROM 	(values 
		(88,'2/16',3,3,0),(88,'2/17',4,7,0)
		)A (personID,DocDate,DocID,Fee,ISDeb)
SELECT * FROM #credit
SELECT * FROM #debit


--result:
;WITH res AS
(
	SELECT 88 AS personID ,1 deb_DocID ,5 deb_Fee , 3 Cre_DocID ,3 Cre_Fee, 0 remain_Cre_Fee
	UNION
	SELECT 88 AS personID ,1 deb_DocID ,5 deb_Fee , 4 Cre_DocID ,7 Cre_Fee, 5 remain_Cre_Fee
	UNION
	SELECT 88 AS personID ,2 deb_DocID ,5 deb_Fee , 4 Cre_DocID ,7 Cre_Fee, 0 remain_Cre_Fee
)


SELECT *
FROM res

SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;

<pre>create PROCEDURE [dbo].[mysp] 	
	@sRefDateFrom AS CHAR(8) , @sRefDateTo AS CHAR(8) 	-- Dates are expected in 'YYYYMMDD'
AS
BEGIN
	-- SET NOCOUNT ON added to prevent extra result sets from
	-- interfering with SELECT statements.
	SET NOCOUNT ON;
	SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;
    SELECT  A.FormatCode, A.AcctName , SUM(J.Debit) AS Debit, SUM (J.Credit) AS Credit 
	FROM JN J  					
	 JOIN AC A  
	 ON A.AcctCode = J.Account					
	WHERE J.RefDate >= @sRefDateFrom 					
		AND J.RefDate  <= @sRefDateTo
	GROUP BY A.FormatCode , A.AcctName 					
	ORDER BY A.FormatCode 
END