Очень долго выполняется запрос SQL

SELECT TOP (100) PERCENT derivedtbl_3.Примечание , COUNT(*) AS Количество , avg(derivedtbl_2.Переработка) AS Переработка  FROM   (SELECT TOP (100) PERCENT ОтчетЗИФ_1.Дата  , CASE WHEN (datepart (HOUR, Дата) > '20' OR (datepart (HOUR, Дата) >= '0' AND datepart (HOUR, Дата) <= '8')) THEN 1 ELSE 2  END AS Смена  , dateadd(hh, Hour_Nr, CAST(ОтчетЗИФ_1.Time AS DATETIME)) AS DATA , dateadd(DAY, -1, (dateadd(hh, Hour_Nr, CAST(ОтчетЗИФ_1.Time AS DATETIME)))) AS DATA_1  , CAST(Lk14_summ - (SELECT TOP (1) Lk14_summ FROM  ASUTP.dbo.Report AS t2  WHERE dateadd(hh, Hour_Nr, CAST(TIME AS DATETIME)) < dateadd(hh, ОтчетЗИФ_1.Hour_Nr, CAST(ОтчетЗИФ_1.Time AS DATETIME))  ORDER BY  CASE WHEN datepart (HOUR, (dateadd(hh, Hour_Nr, CAST(TIME AS DATETIME)))) > '20' THEN  dateadd(DAY, -1, (dateadd(hh, Hour_Nr, CAST(TIME AS DATETIME)))) ELSE  dateadd(hh, Hour_Nr, CAST(TIME AS DATETIME))      END DESC) AS INT) AS Переработка  FROM (SELECT TOP (100) PERCENT CASE      WHEN Hour_Nr > 20 THEN  dateadd(HOUR, Hour_Nr, CAST(TIME AS DATETIME) + 1) ELSE  dateadd(HOUR, Hour_Nr, CAST(TIME AS DATETIME))      END AS DATE , TIME , Rashod_N4 , Rashod_N15 FROM ASUTP.dbo.Report AS ОтчетЗИФ_1) AS derivedtbl_1  RIGHT OUTER JOIN dbo.Report AS ОтчетЗИФ_1     ON derivedtbl_1.Date = ОтчетЗИФ_1.Дата   ORDER BY     DATA   , Смена) AS derivedtbl_2  LEFT OUTER JOIN (SELECT Код, Дата, Время , Позиция, Примечание       , dateadd(HOUR, datepart (HOUR, Время), Дата) AS dat FROM dbo.ПримечанияЗИФ  WHERE (Позиция = 'л/к 14 (Переработ-ка л/к №14, т/ч)')) AS derivedtbl_3    ON derivedtbl_2.Дата = derivedtbl_3.dat WHERE  derivedtbl_2.DATA >= '" + FormatDateTime("dd.mm.yyyy",cxDateEdit1->Date) + "'  AND derivedtbl_2.DATA <= '" + FormatDateTime("dd.mm.yyyy",cxDateEdit2->Date) + "'  AND (derivedtbl_2.Переработка <= '" + Edit1->Text + "')  AND (derivedtbl_2.Переработка <> 0) GROUP BY   derivedtbl_3.Примечание ORDER BY   derivedtbl_3.Примечание

SELECT     TOP (100) PERCENT DATE, Lk14_summ, Lk14_summ -
                          (SELECT     TOP (1) Lk14_summ
                            FROM          dbo.Report AS T1
                            WHERE      (DATE < dbo.Report.Date)
                            ORDER BY DATE DESC) AS Expr1
FROM         dbo.Report
WHERE     (TIME BETWEEN '01.09.2017' AND '25.09.2017')
ORDER BY DATE DESC