(@P1 varbinary(16))SELECT
T1.Fld7233RRef,
T7._IDRRef,
T1.Period_,
T7._Number,
T1.RecorderTRef,
T1.RecorderRRef
FROM (SELECT
T6._Fld7231RRef AS Fld7231RRef,
T6._Fld7233RRef AS Fld7233RRef,
T6._Period AS Period_,
T6._RecorderTRef AS RecorderTRef,
T6._RecorderRRef AS RecorderRRef
FROM (SELECT
T3.Fld7231RRef AS Fld7231RRef,
T3.Fld7232RRef AS Fld7232RRef,
T3.MAXPERIOD_ AS MAXPERIOD_,
SUBSTRING(MAX(T5._RecorderTRef + T5._RecorderRRef),1,4) AS MAXRECORDERTRef,
SUBSTRING(MAX(T5._RecorderTRef + T5._RecorderRRef),5,16) AS MAXRECORDERRRef
FROM (SELECT
T4._Fld7231RRef AS Fld7231RRef,
T4._Fld7232RRef AS Fld7232RRef,
MAX(T4._Period) AS MAXPERIOD_
FROM dbo._InfoRg7230 T4
WHERE T4._Active = 0x01
GROUP BY T4._Fld7231RRef,
T4._Fld7232RRef) T3
INNER JOIN dbo._InfoRg7230 T5
ON T3.Fld7231RRef = T5._Fld7231RRef AND T3.Fld7232RRef = T5._Fld7232RRef AND T3.MAXPERIOD_ = T5._Period
WHERE T5._Active = 0x01
GROUP BY T3.Fld7231RRef,
T3.Fld7232RRef,
T3.MAXPERIOD_) T2
INNER JOIN dbo._InfoRg7230 T6
ON T2.Fld7231RRef = T6._Fld7231RRef AND T2.Fld7232RRef = T6._Fld7232RRef AND T2.MAXPERIOD_ = T6._Period AND T2.MAXRECORDERTRef = T6._RecorderTRef AND T2.MAXRECORDERRRef = T6._RecorderRRef) T1
LEFT OUTER JOIN dbo._Document284 T7
ON T1.Fld7231RRef = T7._IDRRef
WHERE (T1.Fld7231RRef = @P1)

UPDATE T2 SET _Fld8106 = T2._Fld8106 + T1._Fld8173
FROM #tt9 T1 WITH(NOLOCK)
INNER JOIN dbo._AccumRgT8110 T2
ON T1._Period = T2._Period AND T1._Fld8167_TYPE = T2._Fld8100_TYPE AND T1._Fld8167_RTRef = T2._Fld8100_RTRef AND T1._Fld8167_RRRef = T2._Fld8100_RRRef AND T1._Fld8168RRef = T2._Fld8101RRef AND T1._Fld8169RRef = T2._Fld8102RRef AND T1._Fld8170RRef = T2._Fld8103RRef AND T1._Fld8171RRef = T2._Fld8104RRef AND T1._Fld8172_TYPE = T2._Fld8105_TYPE AND T1._Fld8172_RTRef = T2._Fld8105_RTRef AND T1._Fld8172_RRRef = T2._Fld8105_RRRef

UPDATE T2 SET _Fld8106 = T2._Fld8106 + T1._Fld8173
FROM #tt6 T1 WITH(NOLOCK)
INNER JOIN dbo._AccumRgT8110 T2
ON T1._Period = T2._Period AND T1._Fld8167_TYPE = T2._Fld8100_TYPE AND T1._Fld8167_RTRef = T2._Fld8100_RTRef AND T1._Fld8167_RRRef = T2._Fld8100_RRRef AND T1._Fld8168RRef = T2._Fld8101RRef AND T1._Fld8169RRef = T2._Fld8102RRef AND T1._Fld8170RRef = T2._Fld8103RRef AND T1._Fld8171RRef = T2._Fld8104RRef AND T1._Fld8172_TYPE = T2._Fld8105_TYPE AND T1._Fld8172_RTRef = T2._Fld8105_RTRef AND T1._Fld8172_RRRef = T2._Fld8105_RRRef