Код

set nocount on

SELECT
    MAX(tp.date_time_docid) as date_time_docid,
    tp.ktsc0
into #sq
FROM
    _1sentry AS tp (nolock)
Where
    (tp.date_time_docid between :Date01 and :Date02 ~) AND
    (tp.KTSC0 IN (SELECT val FROM #ktg)) AND
    tp.accktid IN (SELECT val FROM #accs) AND
    ((tp.AccDtId IN (SELECT val FROM #accsd01)) OR (tp.AccDtId IN (SELECT val FROM #accsd02))) AND
    (tp.ACTIVE='')
GROUP BY  
    tp.ktsc0

SELECT
    CAST (LEFT(tp.date_time_docid, 8) as DateTime) as ДатаДк ,
    tp.ktsc0 AS Kt,
    right(tp.date_time_docid, 9) AS Док,  
    jur.iddocdef As Док_вид,
    SUM(tp.SUM_) AS sum_op  
FROM
    _1sentry AS tp (nolock)
    inner join _1sjourn AS jur (nolock) on tp.date_time_docid = jur.date_time_iddoc
    inner join #sq sq on tp.date_time_docid = sq.date_time_docid and tp.ktsc0 = sq.ktsc0
Where
    (tp.date_time_docid between :Date01 and :Date02 ~) AND
    (tp.KTSC0 IN (SELECT val FROM #ktg)) AND
    tp.accktid IN (SELECT val FROM #accs) AND
    ((tp.AccDtId IN (SELECT val FROM #accsd01)) OR (tp.AccDtId IN (SELECT val FROM #accsd02))) AND
    (tp.ACTIVE='')
GROUP BY  
    tp.ktsc0,
    tp.date_time_docid,
    jur.iddocdef