INSERT INTO #tt18
(_Period, _AccountRRef, _Fld4999RRef, _Fld5000, _EDValue1_TYPE, _EDValue1_RTRef, _EDValue1_RRRef, _EDValue2_TYPE, _EDValue2_RTRef, _EDValue2_RRRef, _EDValue3_TYPE, _EDValue3_RTRef, _EDValue3_RRRef, _EDValue4_TYPE, _EDValue4_RTRef, _EDValue4_RRRef, _EDValue5_TYPE, _EDValue5_RTRef, _EDValue5_RRRef, _Fld5001, _TurnoverDt5007, _TurnoverCt5008, _Turnover5009, _Fld5002, _TurnoverDt5010, _TurnoverCt5011, _Turnover5012, _Fld5003, _TurnoverDt5013, _TurnoverCt5014, _Turnover5015)
SELECT
{ts '2011-01-01 00:00:00'} AS _Period,
#V8TblAli1_R._AccountRRef AS _AccountRRef,
#V8TblAli1_R._Fld4999RRef AS _Fld4999RRef,
#V8TblAli1_R._Fld5000 AS _Fld5000,
#V8TblAli1_R._EDValue1_TYPE AS _EDValue1_TYPE,
#V8TblAli1_R._EDValue1_RTRef AS _EDValue1_RTRef,
#V8TblAli1_R._EDValue1_RRRef AS _EDValue1_RRRef,
#V8TblAli1_R._EDValue2_TYPE AS _EDValue2_TYPE,
#V8TblAli1_R._EDValue2_RTRef AS _EDValue2_RTRef,
#V8TblAli1_R._EDValue2_RRRef AS _EDValue2_RRRef,
#V8TblAli1_R._EDValue3_TYPE AS _EDValue3_TYPE,
#V8TblAli1_R._EDValue3_RTRef AS _EDValue3_RTRef,
#V8TblAli1_R._EDValue3_RRRef AS _EDValue3_RRRef,
#V8TblAli1_R._EDValue4_TYPE AS _EDValue4_TYPE,
#V8TblAli1_R._EDValue4_RTRef AS _EDValue4_RTRef,
#V8TblAli1_R._EDValue4_RRRef AS _EDValue4_RRRef,
#V8TblAli1_R._EDValue5_TYPE AS _EDValue5_TYPE,
#V8TblAli1_R._EDValue5_RTRef AS _EDValue5_RTRef,
#V8TblAli1_R._EDValue5_RRRef AS _EDValue5_RRRef,
CAST(0. AS NUMERIC(1,0)) AS _Fld5001,
CAST(SUM(#V8TblAli1_R._TurnoverDt5007) AS NUMERIC(21,2)) AS _TurnoverDt5007,
CAST(SUM(#V8TblAli1_R._TurnoverCt5008) AS NUMERIC(21,2)) AS _TurnoverCt5008,
CAST(SUM(#V8TblAli1_R._TurnoverDt5007 - #V8TblAli1_R._TurnoverCt5008) AS NUMERIC(22,2)) AS _Turnover5009,
CAST(0. AS NUMERIC(1,0)) AS _Fld5002,
CAST(SUM(#V8TblAli1_R._TurnoverDt5010) AS NUMERIC(21,2)) AS _TurnoverDt5010,
CAST(SUM(#V8TblAli1_R._TurnoverCt5011) AS NUMERIC(21,2)) AS _TurnoverCt5011,
CAST(SUM(#V8TblAli1_R._TurnoverDt5010 - #V8TblAli1_R._TurnoverCt5011) AS NUMERIC(22,2)) AS _Turnover5012,
CAST(0. AS NUMERIC(1,0)) AS _Fld5003,
CAST(SUM(#V8TblAli1_R._TurnoverDt5013) AS NUMERIC(21,3)) AS _TurnoverDt5013,
CAST(SUM(#V8TblAli1_R._TurnoverCt5014) AS NUMERIC(21,3)) AS _TurnoverCt5014,
CAST(SUM(#V8TblAli1_R._TurnoverDt5013 - #V8TblAli1_R._TurnoverCt5014) AS NUMERIC(22,3)) AS _Turnover5015
FROM
(
SELECT
_AccRg4998_R._AccountDtRRef AS _AccountRRef,
_AccRg4998_R._Fld4999DtRRef AS _Fld4999RRef,
_AccRg4998_R._Fld5000 AS _Fld5000,
#Accounts_Acc._EDCount AS _EDCount,
_AccRgED5022_TEDActions1._Value_TYPE AS _EDValue1_TYPE,
_AccRgED5022_TEDActions1._Value_RTRef AS _EDValue1_RTRef,
_AccRgED5022_TEDActions1._Value_RRRef AS _EDValue1_RRRef,
_AccRgED5022_TEDActions2._Value_TYPE AS _EDValue2_TYPE,
_AccRgED5022_TEDActions2._Value_RTRef AS _EDValue2_RTRef,
_AccRgED5022_TEDActions2._Value_RRRef AS _EDValue2_RRRef,
_AccRgED5022_TEDActions3._Value_TYPE AS _EDValue3_TYPE,
_AccRgED5022_TEDActions3._Value_RTRef AS _EDValue3_RTRef,
_AccRgED5022_TEDActions3._Value_RRRef AS _EDValue3_RRRef,
_AccRgED5022_TEDActions4._Value_TYPE AS _EDValue4_TYPE,
_AccRgED5022_TEDActions4._Value_RTRef AS _EDValue4_RTRef,
_AccRgED5022_TEDActions4._Value_RRRef AS _EDValue4_RRRef,
_AccRgED5022_TEDActions5._Value_TYPE AS _EDValue5_TYPE,
_AccRgED5022_TEDActions5._Value_RTRef AS _EDValue5_RTRef,
_AccRgED5022_TEDActions5._Value_RRRef AS _EDValue5_RRRef,
_AccRg4998_R._Fld5001 AS _TurnoverDt5007,
CAST(CAST(0. AS NUMERIC(1,0)) AS NUMERIC(15,2)) AS _TurnoverCt5008,
_AccRg4998_R._Fld5002Dt AS _TurnoverDt5010,
CAST(CAST(0. AS NUMERIC(1,0)) AS NUMERIC(15,2)) AS _TurnoverCt5011,
_AccRg4998_R._Fld5003Dt AS _TurnoverDt5013,
CAST(CAST(0. AS NUMERIC(1,0)) AS NUMERIC(15,3)) AS _TurnoverCt5014
FROM
_AccRg4998 _AccRg4998_R WITH(SERIALIZABLE)
INNER JOIN #tt12 #Accounts_Acc WITH(NOLOCK)
ON #Accounts_Acc._IDRRef = _AccRg4998_R._AccountDtRRef AND #Accounts_Acc._EDCount = CAST(5 AS NUMERIC(1,0))
LEFT OUTER JOIN _Acc5_ExtDim4943 _Acc5_ExtDim4943_TEDAccounts1 WITH(REPEATABLEREAD)
ON _Acc5_ExtDim4943_TEDAccounts1._Acc5_IDRRef = _AccRg4998_R._AccountDtRRef AND _Acc5_ExtDim4943_TEDAccounts1._LineNo = CAST(1 AS NUMERIC(1,0))
LEFT OUTER JOIN _AccRgED5022 _AccRgED5022_TEDActions1 WITH(SERIALIZABLE)
ON _AccRgED5022_TEDActions1._Period >= {ts '2011-01-01 00:00:00'} AND _AccRgED5022_TEDActions1._Period < {ts '2011-02-01 00:00:00'} AND _AccRgED5022_TEDActions1._Period = _AccRg4998_R._Period AND _AccRgED5022_TEDActions1._RecorderTRef = _AccRg4998_R._RecorderTRef AND _AccRgED5022_TEDActions1._RecorderRRef = _AccRg4998_R._RecorderRRef AND _AccRgED5022_TEDActions1._LineNo = _AccRg4998_R._LineNo AND _AccRgED5022_TEDActions1._Correspond = CAST(0. AS NUMERIC(1,0)) AND _AccRgED5022_TEDActions1._KindRRef = _Acc5_ExtDim4943_TEDAccounts1._DimKindRRef
LEFT OUTER JOIN _Acc5_ExtDim4943 _Acc5_ExtDim4943_TEDAccounts2 WITH(REPEATABLEREAD)
ON _Acc5_ExtDim4943_TEDAccounts2._Acc5_IDRRef = _AccRg4998_R._AccountDtRRef AND _Acc5_ExtDim4943_TEDAccounts2._LineNo = CAST(2 AS NUMERIC(1,0))
LEFT OUTER JOIN _AccRgED5022 _AccRgED5022_TEDActions2 WITH(SERIALIZABLE)
ON _AccRgED5022_TEDActions2._Period >= {ts '2011-01-01 00:00:00'} AND _AccRgED5022_TEDActions2._Period < {ts '2011-02-01 00:00:00'} AND _AccRgED5022_TEDActions2._Period = _AccRg4998_R._Period AND _AccRgED5022_TEDActions2._RecorderTRef = _AccRg4998_R._RecorderTRef AND _AccRgED5022_TEDActions2._RecorderRRef = _AccRg4998_R._RecorderRRef AND _AccRgED5022_TEDActions2._LineNo = _AccRg4998_R._LineNo AND _AccRgED5022_TEDActions2._Correspond = CAST(0. AS NUMERIC(1,0)) AND _AccRgED5022_TEDActions2._KindRRef = _Acc5_ExtDim4943_TEDAccounts2._DimKindRRef
LEFT OUTER JOIN _Acc5_ExtDim4943 _Acc5_ExtDim4943_TEDAccounts3 WITH(REPEATABLEREAD)
ON _Acc5_ExtDim4943_TEDAccounts3._Acc5_IDRRef = _AccRg4998_R._AccountDtRRef AND _Acc5_ExtDim4943_TEDAccounts3._LineNo = CAST(3 AS NUMERIC(1,0))
LEFT OUTER JOIN _AccRgED5022 _AccRgED5022_TEDActions3 WITH(SERIALIZABLE)
ON _AccRgED5022_TEDActions3._Period >= {ts '2011-01-01 00:00:00'} AND _AccRgED5022_TEDActions3._Period < {ts '2011-02-01 00:00:00'} AND _AccRgED5022_TEDActions3._Period = _AccRg4998_R._Period AND _AccRgED5022_TEDActions3._RecorderTRef = _AccRg4998_R._RecorderTRef AND _AccRgED5022_TEDActions3._RecorderRRef = _AccRg4998_R._RecorderRRef AND _AccRgED5022_TEDActions3._LineNo = _AccRg4998_R._LineNo AND _AccRgED5022_TEDActions3._Correspond = CAST(0. AS NUMERIC(1,0)) AND _AccRgED5022_TEDActions3._KindRRef = _Acc5_ExtDim4943_TEDAccounts3._DimKindRRef
LEFT OUTER JOIN _Acc5_ExtDim4943 _Acc5_ExtDim4943_TEDAccounts4 WITH(REPEATABLEREAD)
ON _Acc5_ExtDim4943_TEDAccounts4._Acc5_IDRRef = _AccRg4998_R._AccountDtRRef AND _Acc5_ExtDim4943_TEDAccounts4._LineNo = CAST(4 AS NUMERIC(1,0))
LEFT OUTER JOIN _AccRgED5022 _AccRgED5022_TEDActions4 WITH(SERIALIZABLE)
ON _AccRgED5022_TEDActions4._Period >= {ts '2011-01-01 00:00:00'} AND _AccRgED5022_TEDActions4._Period < {ts '2011-02-01 00:00:00'} AND _AccRgED5022_TEDActions4._Period = _AccRg4998_R._Period AND _AccRgED5022_TEDActions4._RecorderTRef = _AccRg4998_R._RecorderTRef AND _AccRgED5022_TEDActions4._RecorderRRef = _AccRg4998_R._RecorderRRef AND _AccRgED5022_TEDActions4._LineNo = _AccRg4998_R._LineNo AND _AccRgED5022_TEDActions4._Correspond = CAST(0. AS NUMERIC(1,0)) AND _AccRgED5022_TEDActions4._KindRRef = _Acc5_ExtDim4943_TEDAccounts4._DimKindRRef
LEFT OUTER JOIN _Acc5_ExtDim4943 _Acc5_ExtDim4943_TEDAccounts5 WITH(REPEATABLEREAD)
ON _Acc5_ExtDim4943_TEDAccounts5._Acc5_IDRRef = _AccRg4998_R._AccountDtRRef AND _Acc5_ExtDim4943_TEDAccounts5._LineNo = CAST(5 AS NUMERIC(1,0))
LEFT OUTER JOIN _AccRgED5022 _AccRgED5022_TEDActions5 WITH(SERIALIZABLE)
ON _AccRgED5022_TEDActions5._Period >= {ts '2011-01-01 00:00:00'} AND _AccRgED5022_TEDActions5._Period < {ts '2011-02-01 00:00:00'} AND _AccRgED5022_TEDActions5._Period = _AccRg4998_R._Period AND _AccRgED5022_TEDActions5._RecorderTRef = _AccRg4998_R._RecorderTRef AND _AccRgED5022_TEDActions5._RecorderRRef = _AccRg4998_R._RecorderRRef AND _AccRgED5022_TEDActions5._LineNo = _AccRg4998_R._LineNo AND _AccRgED5022_TEDActions5._Correspond = CAST(0. AS NUMERIC(1,0)) AND _AccRgED5022_TEDActions5._KindRRef = _Acc5_ExtDim4943_TEDAccounts5._DimKindRRef
WHERE
_AccRg4998_R._Active = @P1 AND _AccRg4998_R._Period >= @P2 AND _AccRg4998_R._Period < @P3
UNION ALL
SELECT
_AccRg4998_R._AccountCtRRef AS _AccountRRef,
_AccRg4998_R._Fld4999CtRRef AS _Fld4999RRef,
_AccRg4998_R._Fld5000 AS _Fld5000,
#Accounts_Acc._EDCount AS _EDCount,
_AccRgED5022_TEDActions1._Value_TYPE AS _EDValue1_TYPE,
_AccRgED5022_TEDActions1._Value_RTRef AS _EDValue1_RTRef,
_AccRgED5022_TEDActions1._Value_RRRef AS _EDValue1_RRRef,
_AccRgED5022_TEDActions2._Value_TYPE AS _EDValue2_TYPE,
_AccRgED5022_TEDActions2._Value_RTRef AS _EDValue2_RTRef,
_AccRgED5022_TEDActions2._Value_RRRef AS _EDValue2_RRRef,
_AccRgED5022_TEDActions3._Value_TYPE AS _EDValue3_TYPE,
_AccRgED5022_TEDActions3._Value_RTRef AS _EDValue3_RTRef,
_AccRgED5022_TEDActions3._Value_RRRef AS _EDValue3_RRRef,
_AccRgED5022_TEDActions4._Value_TYPE AS _EDValue4_TYPE,
_AccRgED5022_TEDActions4._Value_RTRef AS _EDValue4_RTRef,
_AccRgED5022_TEDActions4._Value_RRRef AS _EDValue4_RRRef,
_AccRgED5022_TEDActions5._Value_TYPE AS _EDValue5_TYPE,
_AccRgED5022_TEDActions5._Value_RTRef AS _EDValue5_RTRef,
_AccRgED5022_TEDActions5._Value_RRRef AS _EDValue5_RRRef,
CAST(CAST(0. AS NUMERIC(1,0)) AS NUMERIC(15,2)) AS _TurnoverDt5007,
_AccRg4998_R._Fld5001 AS _TurnoverCt5008,
CAST(CAST(0. AS NUMERIC(1,0)) AS NUMERIC(15,2)) AS _TurnoverDt5010,
_AccRg4998_R._Fld5002Ct AS _TurnoverCt5011,
CAST(CAST(0. AS NUMERIC(1,0)) AS NUMERIC(15,3)) AS _TurnoverDt5013,
_AccRg4998_R._Fld5003Ct AS _TurnoverCt5014
FROM
_AccRg4998 _AccRg4998_R WITH(SERIALIZABLE)
INNER JOIN #tt12 #Accounts_Acc WITH(NOLOCK)
ON #Accounts_Acc._IDRRef = _AccRg4998_R._AccountCtRRef AND #Accounts_Acc._EDCount = CAST(5 AS NUMERIC(1,0))
LEFT OUTER JOIN _Acc5_ExtDim4943 _Acc5_ExtDim4943_TEDAccounts1 WITH(REPEATABLEREAD)
ON _Acc5_ExtDim4943_TEDAccounts1._Acc5_IDRRef = _AccRg4998_R._AccountCtRRef AND _Acc5_ExtDim4943_TEDAccounts1._LineNo = CAST(1 AS NUMERIC(1,0))
LEFT OUTER JOIN _AccRgED5022 _AccRgED5022_TEDActions1 WITH(SERIALIZABLE)
ON _AccRgED5022_TEDActions1._Period >= {ts '2011-01-01 00:00:00'} AND _AccRgED5022_TEDActions1._Period < {ts '2011-02-01 00:00:00'} AND _AccRgED5022_TEDActions1._Period = _AccRg4998_R._Period AND _AccRgED5022_TEDActions1._RecorderTRef = _AccRg4998_R._RecorderTRef AND _AccRgED5022_TEDActions1._RecorderRRef = _AccRg4998_R._RecorderRRef AND _AccRgED5022_TEDActions1._LineNo = _AccRg4998_R._LineNo AND _AccRgED5022_TEDActions1._Correspond = CAST(1 AS NUMERIC(1,0)) AND _AccRgED5022_TEDActions1._KindRRef = _Acc5_ExtDim4943_TEDAccounts1._DimKindRRef
LEFT OUTER JOIN _Acc5_ExtDim4943 _Acc5_ExtDim4943_TEDAccounts2 WITH(REPEATABLEREAD)
ON _Acc5_ExtDim4943_TEDAccounts2._Acc5_IDRRef = _AccRg4998_R._AccountCtRRef AND _Acc5_ExtDim4943_TEDAccounts2._LineNo = CAST(2 AS NUMERIC(1,0))
LEFT OUTER JOIN _AccRgED5022 _AccRgED5022_TEDActions2 WITH(SERIALIZABLE)
ON _AccRgED5022_TEDActions2._Period >= {ts '2011-01-01 00:00:00'} AND _AccRgED5022_TEDActions2._Period < {ts '2011-02-01 00:00:00'} AND _AccRgED5022_TEDActions2._Period = _AccRg4998_R._Period AND _AccRgED5022_TEDActions2._RecorderTRef = _AccRg4998_R._RecorderTRef AND _AccRgED5022_TEDActions2._RecorderRRef = _AccRg4998_R._RecorderRRef AND _AccRgED5022_TEDActions2._LineNo = _AccRg4998_R._LineNo AND _AccRgED5022_TEDActions2._Correspond = CAST(1 AS NUMERIC(1,0)) AND _AccRgED5022_TEDActions2._KindRRef = _Acc5_ExtDim4943_TEDAccounts2._DimKindRRef
LEFT OUTER JOIN _Acc5_ExtDim4943 _Acc5_ExtDim4943_TEDAccounts3 WITH(REPEATABLEREAD)
ON _Acc5_ExtDim4943_TEDAccounts3._Acc5_IDRRef = _AccRg4998_R._AccountCtRRef AND _Acc5_ExtDim4943_TEDAccounts3._LineNo = CAST(3 AS NUMERIC(1,0))
LEFT OUTER JOIN _AccRgED5022 _AccRgED5022_TEDActions3 WITH(SERIALIZABLE)
ON _AccRgED5022_TEDActions3._Period >= {ts '2011-01-01 00:00:00'} AND _AccRgED5022_TEDActions3._Period < {ts '2011-02-01 00:00:00'} AND _AccRgED5022_TEDActions3._Period = _AccRg4998_R._Period AND _AccRgED5022_TEDActions3._RecorderTRef = _AccRg4998_R._RecorderTRef AND _AccRgED5022_TEDActions3._RecorderRRef = _AccRg4998_R._RecorderRRef AND _AccRgED5022_TEDActions3._LineNo = _AccRg4998_R._LineNo AND _AccRgED5022_TEDActions3._Correspond = CAST(1 AS NUMERIC(1,0)) AND _AccRgED5022_TEDActions3._KindRRef = _Acc5_ExtDim4943_TEDAccounts3._DimKindRRef
LEFT OUTER JOIN _Acc5_ExtDim4943 _Acc5_ExtDim4943_TEDAccounts4 WITH(REPEATABLEREAD)
ON _Acc5_ExtDim4943_TEDAccounts4._Acc5_IDRRef = _AccRg4998_R._AccountCtRRef AND _Acc5_ExtDim4943_TEDAccounts4._LineNo = CAST(4 AS NUMERIC(1,0))
LEFT OUTER JOIN _AccRgED5022 _AccRgED5022_TEDActions4 WITH(SERIALIZABLE)
ON _AccRgED5022_TEDActions4._Period >= {ts '2011-01-01 00:00:00'} AND _AccRgED5022_TEDActions4._Period < {ts '2011-02-01 00:00:00'} AND _AccRgED5022_TEDActions4._Period = _AccRg4998_R._Period AND _AccRgED5022_TEDActions4._RecorderTRef = _AccRg4998_R._RecorderTRef AND _AccRgED5022_TEDActions4._RecorderRRef = _AccRg4998_R._RecorderRRef AND _AccRgED5022_TEDActions4._LineNo = _AccRg4998_R._LineNo AND _AccRgED5022_TEDActions4._Correspond = CAST(1 AS NUMERIC(1,0)) AND _AccRgED5022_TEDActions4._KindRRef = _Acc5_ExtDim4943_TEDAccounts4._DimKindRRef
LEFT OUTER JOIN _Acc5_ExtDim4943 _Acc5_ExtDim4943_TEDAccounts5 WITH(REPEATABLEREAD)
ON _Acc5_ExtDim4943_TEDAccounts5._Acc5_IDRRef = _AccRg4998_R._AccountCtRRef AND _Acc5_ExtDim4943_TEDAccounts5._LineNo = CAST(5 AS NUMERIC(1,0))
LEFT OUTER JOIN _AccRgED5022 _AccRgED5022_TEDActions5 WITH(SERIALIZABLE)
ON _AccRgED5022_TEDActions5._Period >= {ts '2011-01-01 00:00:00'} AND _AccRgED5022_TEDActions5._Period < {ts '2011-02-01 00:00:00'} AND _AccRgED5022_TEDActions5._Period = _AccRg4998_R._Period AND _AccRgED5022_TEDActions5._RecorderTRef = _AccRg4998_R._RecorderTRef AND _AccRgED5022_TEDActions5._RecorderRRef = _AccRg4998_R._RecorderRRef AND _AccRgED5022_TEDActions5._LineNo = _AccRg4998_R._LineNo AND _AccRgED5022_TEDActions5._Correspond = CAST(1 AS NUMERIC(1,0)) AND _AccRgED5022_TEDActions5._KindRRef = _Acc5_ExtDim4943_TEDAccounts5._DimKindRRef
WHERE
_AccRg4998_R._Active = @P1 AND _AccRg4998_R._Period >= @P2 AND _AccRg4998_R._Period < @P3
) #V8TblAli1_R
GROUP BY
#V8TblAli1_R._AccountRRef,
#V8TblAli1_R._Fld4999RRef,
#V8TblAli1_R._Fld5000,
#V8TblAli1_R._EDValue1_TYPE,
#V8TblAli1_R._EDValue1_RTRef,
#V8TblAli1_R._EDValue1_RRRef,
#V8TblAli1_R._EDValue2_TYPE,
#V8TblAli1_R._EDValue2_RTRef,
#V8TblAli1_R._EDValue2_RRRef,
#V8TblAli1_R._EDValue3_TYPE,
#V8TblAli1_R._EDValue3_RTRef,
#V8TblAli1_R._EDValue3_RRRef,
#V8TblAli1_R._EDValue4_TYPE,
#V8TblAli1_R._EDValue4_RTRef,
#V8TblAli1_R._EDValue4_RRRef,
#V8TblAli1_R._EDValue5_TYPE,
#V8TblAli1_R._EDValue5_RTRef,
#V8TblAli1_R._EDValue5_RRRef