Pasted

INSERT INTO #tt5 WITH(TABLOCK) (_Q_001_F_000RRef, _Q_001_F_001RRef, _Q_001_F_002RRef, _Q_001_F_003) SELECT
T1._Q_000_F_000RRef,
ISNULL(T2._IDRRef,@P1),
ISNULL(T3._IDRRef,@P2),
T1._Q_000_F_004
FROM #tt4 T1 WITH(NOLOCK)
LEFT OUTER JOIN dbo._Reference118 T2
ON (CASE WHEN ((T1._Q_000_F_002 = 0x00) OR (T1._Q_000_F_003RRef = @P3)) THEN 0x00 ELSE CASE WHEN (T1._Q_000_F_003RRef = @P4) THEN CASE WHEN (CASE WHEN T1._Q_000_F_001RRef IS NOT NULL THEN 0x08 END = T2._OwnerID_TYPE AND CASE WHEN T1._Q_000_F_001RRef IS NOT NULL THEN 0x00000025 END = T2._OwnerID_RTRef AND T1._Q_000_F_001RRef = T2._OwnerID_RRRef) THEN 0x01 WHEN NOT (CASE WHEN T1._Q_000_F_001RRef IS NOT NULL THEN 0x08 END = T2._OwnerID_TYPE AND CASE WHEN T1._Q_000_F_001RRef IS NOT NULL THEN 0x00000025 END = T2._OwnerID_RTRef AND T1._Q_000_F_001RRef = T2._OwnerID_RRRef) THEN 0x00 END ELSE CASE WHEN (CASE WHEN T1._Q_000_F_000RRef IS NOT NULL THEN 0x08 END = T2._OwnerID_TYPE AND CASE WHEN T1._Q_000_F_000RRef IS NOT NULL THEN 0x00000047 END = T2._OwnerID_RTRef AND T1._Q_000_F_000RRef = T2._OwnerID_RRRef) THEN 0x01 WHEN NOT (CASE WHEN T1._Q_000_F_000RRef IS NOT NULL THEN 0x08 END = T2._OwnerID_TYPE AND CASE WHEN T1._Q_000_F_000RRef IS NOT NULL THEN 0x00000047 END = T2._OwnerID_RTRef AND T1._Q_000_F_000RRef = T2._OwnerID_RRRef) THEN 0x00 END END END) = 0x01 AND (T2._Fld346 = @P5)
LEFT OUTER JOIN dbo._Reference112 T3
ON (CASE WHEN (T1._Q_000_F_005RRef = @P6) THEN CASE WHEN (CASE WHEN T1._Q_000_F_000RRef IS NOT NULL THEN 0x08 END = T3._OwnerID_TYPE AND CASE WHEN T1._Q_000_F_000RRef IS NOT NULL THEN 0x00000047 END = T3._OwnerID_RTRef AND T1._Q_000_F_000RRef = T3._OwnerID_RRRef) THEN 0x01 WHEN NOT (CASE WHEN T1._Q_000_F_000RRef IS NOT NULL THEN 0x08 END = T3._OwnerID_TYPE AND CASE WHEN T1._Q_000_F_000RRef IS NOT NULL THEN 0x00000047 END = T3._OwnerID_RTRef AND T1._Q_000_F_000RRef = T3._OwnerID_RRRef) THEN 0x00 END ELSE CASE WHEN (CASE WHEN T1._Q_000_F_005RRef IS NOT NULL THEN 0x08 END = T3._OwnerID_TYPE AND CASE WHEN T1._Q_000_F_005RRef IS NOT NULL THEN 0x00000042 END = T3._OwnerID_RTRef AND T1._Q_000_F_005RRef = T3._OwnerID_RRRef) THEN 0x01 WHEN NOT (CASE WHEN T1._Q_000_F_005RRef IS NOT NULL THEN 0x08 END = T3._OwnerID_TYPE AND CASE WHEN T1._Q_000_F_005RRef IS NOT NULL THEN 0x00000042 END = T3._OwnerID_RTRef AND T1._Q_000_F_005RRef = T3._OwnerID_RRRef) THEN 0x00 END END) = 0x01 AND (T3._Fld346 = @P7)