drop table #Temp2

        SELECT

            m.matvdata as dt_historico,

            CONVERT(VARCHAR(5), m.matvdata, 108) AS hr_historico,

            b.trsacao AS st_situacao_historico,

            msg.msgtexto AS de_detalhamento_historico,

            (SELECT TOP 1

                 matvcod

             FROM

                (

                 SELECT

                     matvcod

                 FROM

                     SISDPVAT.ldr_relatoriopagamento

                 WHERE

                     matvcod = m.matvcod

                 UNION

                 SELECT

                     matvcod

                 FROM

                     SISDPVAT.ldr_protocoloentregadocumentos

                 WHERE

                     matvcod = m.matvcod

                ) r

            ) AS id_rel_dinamico,

        m.matvcod,

        b.trstag as trstag,

        s.atvcod

        into #temp2

        FROM

            msg

        JOIN 

            movimentosatv m

        ON 

            msg.matvcod = m.matvcod

        JOIN 

            bib_transicoes b

        ON 

            b.trscod = m.trscod AND B.DTECOD = m.DTECOD

        JOIN 

            SISDPVAT.ldr_sinistro s

        ON 

            s.atvcod = m.atvcod

        WHERE

            MSGEMAIL IS NULL AND

            (S.SINNUMSINISTRO = '3180204334' OR

            S.SINAVISOPROVISORIOCOMPLETO = '3180204334' OR

            S.SINNUMPROTOCOLOAVISOPROVISORIO = '3180204334')     

        ORDER BY

            m.matvdata

        DESC

​

        select  convert ( varchar(10) , #temp2.dt_historico, 103)  as dt_historico,

        #temp2.hr_historico,

        #temp2.st_situacao_historico,

        #temp2.de_detalhamento_historico,

        #temp2.id_rel_dinamico,

        #temp2.matvcod,

        #temp2.trstag,

        #temp2.atvcod,

        COALESCE(a.arqid, (

                SELECT TOP 1

                    arqid 

                FROM 

                    arquivo a

                JOIN documento d

                    ON a.docid = d.docid 

                WHERE 

                    ((arqnomeinterno LIKE 'ANEXONEGATIVATECNICA%' AND #temp2.trstag IN ('SIN_NEGA_TEC2', 'SIN_NEGA_TEC1')) OR

                     (arqnomeinterno LIKE 'ANEXONEGATIVATECNICANEGADONOTIFICAR%' AND #temp2.trstag IN ('NEGATIVATECNICA', 'NOTIFICARPROCESSONEGADO'))) AND

                    d.atvcod = #temp2.atvcod

                ORDER BY

                    arqdate DESC

            )) AS id_anexo

        from #Temp2

        left join arquivo a ON 

            a.matvcod = #temp2.matvcod 

    order by    #temp2.dt_historico desc

​