SELECT
    initiator.Dop3 AS initDrop,
    MAX(job.EndDate) AS maxEndDate,
    podrini.NameAn AS 'Подразделение инициатора',
    doc.Name AS 'Наименование документа',
    doc.Dop AS 'Номер документа',
    CONVERT(VARCHAR(10), doc.Date4, 104) AS 'Дата документа',
    (SELECT Dop3 FROM MBAnalit WHERE (Analit = job.Executor)) AS 'Исполнитель',
    perfrab.Stroka AS 'Должность',
    podr.NameAn AS 'Подразделение исполнителя',
    job.ResultTitle AS 'Результат выполнения',
    CONVERT(VARCHAR(10), job.EndDate, 104) AS 'Дата согласования',
    CONVERT(VARCHAR(8000), SUBSTRING(Text.Text, 1, 8000)) AS 'Текст задания'
FROM SBTaskJob AS job
    INNER JOIN SBTaskAttach AS att ON job.TaskID = att.TaskID
    INNER JOIN SBEDoc AS doc ON att.AttachID = doc.XRecID
    INNER JOIN SBTaskText AS Text ON job.XRecID = Text.JobID
    INNER JOIN SBTask AS task ON job.TaskID = task.XRecID
    INNER JOIN MBAnalit AS initiator ON task.Author = initiator.Analit
    INNER JOIN MBAnalit AS inirab ON initiator.Analit = inirab.Polzovatel
    INNER JOIN MBAnalit AS perfrab ON job.Executor = perfrab.Polzovatel
    INNER JOIN MBAnalit AS podr ON perfrab.Podr = podr.Analit
    INNER JOIN MBAnalit AS podrini ON inirab.Podr = podrini.Analit
WHERE
    (att.AttachID = @IDDOC) AND
    (job.ResultTitle IN ('Согласовано', 'Не согласовано'))
    AND (inirab.Vid = 288)
    AND (perfrab.Vid = 288)
    AND (podr.Vid = 446)
    AND (podrini.Vid = 446)
GROUP BY
    initDrop, maxEndDate