UPDATE #temp1
SET    EngStatus          = b.Status ,
       full_business_name = b.full_business_name
FROM   #temp1 a                                                                              ,
       (SELECT DISTINCT tet.LocEngNbr                                                        ,
                        dbo.tblCompany.full_business_name                                    ,
                        dbo.tblCompany.duns                                                  ,
                        tet.ClientName                                                       ,
                        tet.SubServiceCd                                                     ,
                        dbo.tblSubService.shortDescription AS 'RptService'                   ,
                        dbo.tblSubService.PCAOBCd          AS 'RptPcaob'                     ,
                        dbo.tblCompany.entity_id                                             ,
                        tet.LocEngPartnerLastName + ', ' + tet.LocEngPartnerFirstName AS 'EP',
                        tet.LocEngPartnerEmail                                               ,
                        CASE tet.LocEngStatus
                                         WHEN 'A'
                                         THEN 'Active'
                                         WHEN 'C'
                                         THEN 'Closed'
                        END AS 'Status'
                        --SELECT DISTINCT tet.LocEngNbr
       FROM             dbo.tblCompany
                        RIGHT OUTER JOIN dbo.tblEngagementTransaction AS tet
                        INNER JOIN dbo.tblCurrencies
                        ON               tet.currencycode = dbo.tblCurrencies.currencyCode
                        INNER JOIN dbo.tblExchangeRate
                        ON               dbo.tblCurrencies.currencyCode = dbo.tblExchangeRate.currencyCode
                        INNER JOIN dbo.tblCalendar
                        ON               tet.CalendarID                 = dbo.tblCalendar.id
                                     AND dbo.tblExchangeRate.calendarid = dbo.tblCalendar.id
                        LEFT OUTER JOIN dbo.tblSubService
                        ON               tet.SubServiceCd         = dbo.tblSubService.code
                        ON               dbo.tblCompany.duns      = tet.Duns
                                     AND LEN(dbo.tblCompany.duns)<>0
       WHERE            tet.UncountryCode                         = @UncountryCode
                    AND tblCalendar.id                            =
                        ( SELECT TOP 1
                                 C.ID
                        FROM     tblEngagementTransaction et
                                 JOIN tblCalendar C
                                 ON       et.CalendarID = C.id
                        WHERE    et.LocEngNbr           = tet.LocEngNbr
                             AND et.UncountryCode       = @UncountryCode
                        ORDER BY C.monthyear DESC
                        )
       ) b
WHERE  a.locEngNbr = b.locEngNbr