exec sp_executesql N'INSERT INTO #tt90 WITH(TABLOCK) (_Q_001_F_000RRef, _Q_001_F_001RRef, _Q_001_F_002RRef, _Q_001_F_003_TYPE, _Q_001_F_003_S, _Q_001_F_003_RRRef, _Q_001_F_004) SELECT TOP 332
T1.Fld34174RRef,
T1.Fld34175RRef,
T1.Fld34173RRef,
T1.Fld35801_TYPE,
T1.Fld35801_S,
T1.Fld35801_RRRef,
CAST(SUM(T1.Fld34179Turnover_) AS NUMERIC(27, 3))
FROM (SELECT
T2._Period AS Period_,
T2._RecorderTRef AS RecorderTRef,
T2._RecorderRRef AS RecorderRRef,
T2._Fld34175RRef AS Fld34175RRef,
T2._Fld34174RRef AS Fld34174RRef,
T2._Fld35801_TYPE AS Fld35801_TYPE,
T2._Fld35801_S AS Fld35801_S,
T2._Fld35801_RRRef AS Fld35801_RRRef,
T2._Fld34173RRef AS Fld34173RRef,
CAST(SUM(CASE WHEN T2._RecordKind = 0.0 THEN T2._Fld34179 ELSE -T2._Fld34179 END) AS NUMERIC(21, 3)) AS Fld34179Turnover_
FROM dbo._AccumRg34172 T2 WITH(NOLOCK)
WHERE T2._Active = 0x01 AND (EXISTS(SELECT
1
FROM #tt85 T3 WITH(NOLOCK)
WHERE (T2._Fld34174RRef = T3._Q_000_F_002RRef) AND (T2._Fld35801_TYPE = CASE WHEN (T3._Q_000_F_017_TYPE = 0x08 AND T3._Q_000_F_017_S = @P1 AND T3._Q_000_F_017_RRRef = @P2) THEN T3._Q_000_F_020_TYPE ELSE T3._Q_000_F_017_TYPE END AND T2._Fld35801_S = CASE WHEN (T3._Q_000_F_017_TYPE = 0x08 AND T3._Q_000_F_017_S = @P3 AND T3._Q_000_F_017_RRRef = @P4) THEN T3._Q_000_F_020_S ELSE T3._Q_000_F_017_S END AND T2._Fld35801_RRRef = CASE WHEN (T3._Q_000_F_017_TYPE = 0x08 AND T3._Q_000_F_017_S = @P5 AND T3._Q_000_F_017_RRRef = @P6) THEN T3._Q_000_F_020_RRRef ELSE T3._Q_000_F_017_RRRef END)))
GROUP BY T2._Period,
T2._RecorderTRef,
T2._RecorderRRef,
T2._Fld34175RRef,
T2._Fld34174RRef,
T2._Fld35801_TYPE,
T2._Fld35801_S,
T2._Fld35801_RRRef,
T2._Fld34173RRef
HAVING (CAST(SUM(CASE WHEN T2._RecordKind = 0.0 THEN T2._Fld34179 ELSE -T2._Fld34179 END) AS NUMERIC(21, 3))) <> 0.0) T1
LEFT OUTER JOIN dbo._Document567 T4 WITH(NOLOCK)
ON T1.RecorderTRef = 0x00000237 AND T1.RecorderRRef = T4._IDRRef
LEFT OUTER JOIN dbo._Document27909 T5 WITH(NOLOCK)
ON T1.RecorderTRef = 0x00006D05 AND T1.RecorderRRef = T5._IDRRef
LEFT OUTER JOIN dbo._Document46085 T6 WITH(NOLOCK)
ON T1.RecorderTRef = 0x0000B405 AND T1.RecorderRRef = T6._IDRRef
WHERE (CASE WHEN T1.RecorderTRef = 0x00000237 THEN T4._Fld16218_TYPE WHEN T1.RecorderTRef = 0x00006D05 THEN T5._Fld27910_TYPE WHEN T1.RecorderTRef = 0x0000B405 THEN CASE WHEN T6._Fld47647RRef IS NOT NULL THEN 0x08 END ELSE CAST(NULL AS BINARY(1)) END = 0x08 AND CASE WHEN T1.RecorderTRef = 0x00000237 THEN T4._Fld16218_RTRef WHEN T1.RecorderTRef = 0x00006D05 THEN T5._Fld27910_RTRef WHEN T1.RecorderTRef = 0x0000B405 THEN CASE WHEN T6._Fld47647RRef IS NOT NULL THEN 0x00000153 END ELSE CAST(NULL AS BINARY(4)) END = 0x0000B405 AND CASE WHEN T1.RecorderTRef = 0x00000237 THEN T4._Fld16218_RRRef WHEN T1.RecorderTRef = 0x00006D05 THEN T5._Fld27910_RRRef WHEN T1.RecorderTRef = 0x0000B405 THEN T6._Fld47647RRef ELSE CAST(NULL AS BINARY(16)) END = @P7)
GROUP BY T1.Fld34174RRef,
T1.Fld34175RRef,
T1.Fld34173RRef,
T1.Fld35801_TYPE,
T1.Fld35801_S,
T1.Fld35801_RRRef',N'@P1 nvarchar(4000),@P2 varbinary(16),@P3 nvarchar(4000),@P4 varbinary(16),@P5 nvarchar(4000),@P6 varbinary(16),@P7 varbinary(16)',N'',0x943500505688064611E49FDF661DC874,N'',0x943500505688064611E49FDF661DC874,N'',0x943500505688064611E49FDF661DC874,0x9C8EAC1F6B0C185F11E95F48CD9A6402