Advertisement
bytecoded

Most Costly Query by CPU (2)

Oct 29th, 2019
337
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 17.03 KB | None | 0 0
  1. (@P1 NUMERIC(10),@P2 varbinary(16),@P3 NUMERIC(10),@P4 NUMERIC(10),@P5 NUMERIC(10),@P6 nvarchar(4000),@P7 NUMERIC(10),@P8 varbinary(16),@P9 NUMERIC(10),@P10 NUMERIC(10),@P11 NUMERIC(10),@P12 NUMERIC(10),@P13 NUMERIC(10),@P14 datetime2(3),@P15 varbinary(16),@P16 NUMERIC(10),@P17 NUMERIC(10),@P18 NUMERIC(10),@P19 datetime2(3),@P20 varbinary(16),@P21 NUMERIC(10),@P22 NUMERIC(10),@P23 NUMERIC(10),@P24 datetime2(3),@P25 datetime2(3),@P26 varbinary(16),@P27 NUMERIC(10),@P28 NUMERIC(10),@P29 NUMERIC(10),@P30 NUMERIC(10),@P31 nvarchar(4000),@P32 NUMERIC(10),@P33 varbinary(16),@P34 NUMERIC(10),@P35 NUMERIC(10),@P36 NUMERIC(10),@P37 NUMERIC(10),@P38 NUMERIC(10),@P39 datetime2(3),@P40 varbinary(16),@P41 NUMERIC(10),@P42 NUMERIC(10),@P43 NUMERIC(10),@P44 varbinary(16),@P45 NUMERIC(10),@P46 NUMERIC(10),@P47 NUMERIC(10),@P48 nvarchar(4000),@P49 NUMERIC(10),@P50 varbinary(16),@P51 NUMERIC(10),@P52 NUMERIC(10),@P53 NUMERIC(10),@P54 NUMERIC(10),@P55 NUMERIC(10),@P56 varbinary(16),@P57 varbinary(16),@P58 datetime2(3),@P59 datetime2(3),@P60 varbinary(16),@P61 NUMERIC(10),@P62 NUMERIC(10),@P63 NUMERIC(10),@P64 NUMERIC(10),@P65 NUMERIC(10),@P66 NUMERIC(10),@P67 NUMERIC(10),@P68 NUMERIC(10),@P69 NUMERIC(10),@P70 NUMERIC(10),@P71 NUMERIC(10),@P72 NUMERIC(10),@P73 NUMERIC(10),@P74 NUMERIC(10),@P75 NUMERIC(10),@P76 NUMERIC(10),@P77 NUMERIC(10),@P78 NUMERIC(10),@P79 NUMERIC(10),@P80 NUMERIC(10),@P81 NUMERIC(10),@P82 NUMERIC(10),@P83 NUMERIC(10),@P84 NUMERIC(10),@P85 NUMERIC(10),@P86 NUMERIC(10),@P87 NUMERIC(10),@P88 NUMERIC(10),@P89 NUMERIC(10),@P90 NUMERIC(10),@P91 varbinary(16),@P92 NUMERIC(10),@P93 NUMERIC(10),@P94 NUMERIC(10),@P95 NUMERIC(10),@P96 NUMERIC(10),@P97 NUMERIC(10),@P98 NUMERIC(10),@P99 NUMERIC(10),@P100 NUMERIC(10),@P101 NUMERIC(10),@P102 NUMERIC(10),@P103 NUMERIC(10),@P104 NUMERIC(10),@P105 NUMERIC(10),@P106 NUMERIC(10),@P107 NUMERIC(10),@P108 NUMERIC(10),@P109 NUMERIC(10),@P110 NUMERIC(10),@P111 NUMERIC(10),@P112 NUMERIC(10),@P113 NUMERIC(10),@P114 NUMERIC(10),@P115 NUMERIC(10),@P116 NUMERIC(10),@P117 NUMERIC(10),@P118 NUMERIC(10),@P119 NUMERIC(10),@P120 NUMERIC(10),@P121 NUMERIC(10),@P122 varbinary(16))SELECT TOP 25
  2. T1._IDRRef,
  3. T1._Marked,
  4. T1._Number,
  5. T1._Date_Time,
  6. T1._Posted,
  7. T1._Fld4621RRef,
  8. T1._Fld4622RRef,
  9. T1._Fld4625RRef,
  10. T1._Fld4627RRef,
  11. T1._Fld4633,
  12. T1._Fld4635RRef,
  13. T1._Fld4657RRef,
  14. CASE WHEN ((T1._Fld4657RRef = 0xAEB7F7D9237C245A447AADE98F164CDF) AND T1._Posted = 0x01) THEN CASE WHEN (ISNULL(CAST(T14.Fld10346Balance_ AS NUMERIC(33, 2)),0.0) > 0.0) THEN CASE WHEN (ISNULL(CAST(T2.Fld11330Turnover_ AS NUMERIC(27, 2)),0.0) = ISNULL(CAST(T4.Fld10545Balance_ AS NUMERIC(27, 2)),0.0)) THEN 4.0 WHEN ((ISNULL(CAST(T4.Fld10545Balance_ AS NUMERIC(27, 2)),0.0) = 0.0) AND (ISNULL(CAST(T2.Fld11330Turnover_ AS NUMERIC(27, 2)),0.0) > 0.0)) THEN 3.0 WHEN ((CAST(ISNULL(CAST(T2.Fld11330Turnover_ AS NUMERIC(27, 2)),0.0) AS NUMERIC(33, 8)) / 2.0) > ISNULL(CAST(T4.Fld10545Balance_ AS NUMERIC(27, 2)),0.0)) THEN 6.0 ELSE 5.0 END ELSE CASE WHEN (ISNULL(CAST(T2.Fld11330Turnover_ AS NUMERIC(27, 2)),0.0) = ISNULL(CAST(T4.Fld10545Balance_ AS NUMERIC(27, 2)),0.0)) THEN 0.0 WHEN ((ISNULL(CAST(T4.Fld10545Balance_ AS NUMERIC(27, 2)),0.0) = 0.0) AND (ISNULL(CAST(T2.Fld11330Turnover_ AS NUMERIC(27, 2)),0.0) > 0.0)) THEN 3.0 WHEN ((CAST(ISNULL(CAST(T2.Fld11330Turnover_ AS NUMERIC(27, 2)),0.0) AS NUMERIC(33, 8)) / 2.0) > ISNULL(CAST(T4.Fld10545Balance_ AS NUMERIC(27, 2)),0.0)) THEN 2.0 ELSE 1.0 END END ELSE 7.0 END,
  15. T19._Fld12313RRef,
  16. T1._Fld13369,
  17. CASE WHEN ((ISNULL(CAST(T20.Fld10335Balance_ AS NUMERIC(27, 2)),0.0) + ISNULL(CAST(T4.Fld10545Balance_ AS NUMERIC(27, 2)),0.0)) > 0.0) THEN (ISNULL(CAST(T20.Fld10335Balance_ AS NUMERIC(27, 2)),0.0) + ISNULL(CAST(T4.Fld10545Balance_ AS NUMERIC(27, 2)),0.0)) ELSE 0.0 END,
  18. CASE WHEN (T1._Fld4657RRef = 0xAEB7F7D9237C245A447AADE98F164CDF) THEN CASE WHEN T1._Posted = 0x01 THEN CASE WHEN T1._Fld14039 = 0x01 THEN CASE WHEN (ISNULL(CAST(T30.Fld14035Expense_ AS NUMERIC(21, 3)),0.0) <= 0.0) THEN 0.0 WHEN ((CAST(ISNULL(CAST(T30.Fld14035Expense_ AS NUMERIC(21, 3)),0.0) AS NUMERIC(26, 8)) / ISNULL(CAST(T30.Fld14035Receipt_ AS NUMERIC(21, 3)),0.0)) <= 0.5) THEN 1.0 WHEN ((CAST(ISNULL(CAST(T30.Fld14035Expense_ AS NUMERIC(21, 3)),0.0) AS NUMERIC(26, 8)) / ISNULL(CAST(T30.Fld14035Receipt_ AS NUMERIC(21, 3)),0.0)) < 1.0) THEN 2.0 WHEN ((CAST(ISNULL(CAST(T30.Fld14035Expense_ AS NUMERIC(21, 3)),0.0) AS NUMERIC(26, 8)) / ISNULL(CAST(T30.Fld14035Receipt_ AS NUMERIC(21, 3)),0.0)) >= 1.0) THEN 3.0 END ELSE 3.0 END ELSE 0.0 END ELSE 7.0 END,
  19. T32._Fld1191
  20. FROM dbo._Document233 T1
  21. LEFT OUTER JOIN (SELECT
  22. T3._Fld11328RRef AS Fld11328RRef,
  23. CAST(SUM(T3._Fld11330) AS NUMERIC(33, 8)) AS Fld11330Turnover_
  24. FROM dbo._AccumRgTn11332 T3
  25. WHERE ((T3._Fld595 = @P1)) AND (((T3._Fld11325RRef = @P2)) AND (T3._Fld11330 <> @P3))
  26. GROUP BY T3._Fld11328RRef
  27. HAVING (CAST(SUM(T3._Fld11330) AS NUMERIC(33, 8))) <> 0.0) T2
  28. ON (T1._IDRRef = T2.Fld11328RRef)
  29. LEFT OUTER JOIN (SELECT
  30. T5._Fld10540_TYPE AS Fld10540_TYPE,
  31. T5._Fld10540_RTRef AS Fld10540_RTRef,
  32. T5._Fld10540_RRRef AS Fld10540_RRRef,
  33. CAST(SUM(T5._Fld10545) AS NUMERIC(33, 8)) AS Fld10545Balance_
  34. FROM dbo._AccumRgT10549 T5
  35. WHERE (((T5._Fld595 = @P4)) AND (EXISTS(SELECT
  36. 1
  37. FROM (SELECT 1 AS SDBL_DUMMY) SDBL_DUAL
  38. LEFT OUTER JOIN dbo._Reference42 T6
  39. ON ((T5._Fld10538RRef = T6._IDRRef)) AND (T6._Fld595 = @P5)
  40. WHERE EXISTS(SELECT
  41. 0x01 AS Q_001_F_000_
  42. FROM dbo._Reference98 T7
  43. INNER JOIN dbo._Reference21 T8
  44. ON (((T7._Fld1685 = @P6) AND EXISTS(SELECT
  45. 0x01 AS Q_004_F_000_
  46. FROM dbo._InfoRg11709 T9
  47. WHERE ((T9._Fld595 = @P7)) AND ((T9._Fld12065RRef = T7._IDRRef) AND (T9._Fld12066RRef = T8._IDRRef)))) AND T8._IDRRef IN
  48. (SELECT
  49. T10._Reference21_IDRRef AS Q_005_F_000RRef
  50. FROM dbo._Reference21_VT782 T10
  51. INNER JOIN dbo._InfoRg9937 T11
  52. ON ((T11._Fld9939_TYPE = 0x08 AND T11._Fld9939_RTRef = 0x00000095 AND T11._Fld9939_RRRef = @P8) AND (T11._Fld9938_TYPE = T10._Fld784_TYPE AND T11._Fld9938_RTRef = T10._Fld784_RTRef AND T11._Fld9938_RRRef = T10._Fld784_RRRef))
  53. WHERE ((T10._Fld595 = @P9)) AND (T11._Fld595 = @P10)))
  54. WHERE ((T8._Fld595 = @P11)) AND ((CASE WHEN T6._Fld12836RRef IS NULL THEN 0x01 ELSE CASE WHEN T6._Fld12836RRef IS NOT NULL THEN 0x08 END END <> 0x01) AND (CASE WHEN EXISTS(SELECT
  55. 0x01 AS Q_002_F_000_
  56. FROM dbo._InfoRg11710 T12
  57. WHERE ((T12._Fld595 = @P12)) AND ((T12._Fld12072RRef = T8._IDRRef) AND (T12._Fld12073_TYPE = CASE WHEN T6._Fld12836RRef IS NOT NULL THEN 0x08 END AND T12._Fld12073_RTRef = CASE WHEN T6._Fld12836RRef IS NOT NULL THEN 0x0000001C END AND T12._Fld12073_RRRef = T6._Fld12836RRef))) THEN 0x01 ELSE 0x00 END = CASE WHEN EXISTS(SELECT
  58. 0x01 AS Q_003_F_000_
  59. FROM dbo._InfoRg11715 T13
  60. WHERE ((T13._Fld595 = @P13)) AND ((T13._Fld12199RRef = T8._IDRRef) AND T13._Fld12200_TYPE = CASE WHEN T6._Fld12836RRef IS NOT NULL THEN 0x08 END AND T13._Fld12200_RTRef = CASE WHEN T6._Fld12836RRef IS NOT NULL THEN 0x0000001C END AND (T13._Fld12201 = 0x00))) THEN 0x01 ELSE 0x00 END)))))) AND (T5._Period = @P14 AND ((T5._Fld10538RRef = @P15)) AND (T5._Fld10545 <> @P16) AND (T5._Fld10545 <> @P17))
  61. GROUP BY T5._Fld10540_TYPE,
  62. T5._Fld10540_RTRef,
  63. T5._Fld10540_RRRef
  64. HAVING (CAST(SUM(T5._Fld10545) AS NUMERIC(33, 8))) <> 0.0) T4
  65. ON (0x08 = T4.Fld10540_TYPE AND 0x000000E9 = T4.Fld10540_RTRef AND T1._IDRRef = T4.Fld10540_RRRef)
  66. LEFT OUTER JOIN (SELECT
  67. T15.Fld10344RRef AS Fld10344RRef,
  68. CAST(SUM(T15.Fld10346Balance_) AS NUMERIC(38, 8)) AS Fld10346Balance_
  69. FROM (SELECT
  70. T16._Fld10344RRef AS Fld10344RRef,
  71. CAST(SUM(T16._Fld10346) AS NUMERIC(33, 8)) AS Fld10346Balance_
  72. FROM dbo._AccumRgT10349 T16
  73. WHERE ((T16._Fld595 = @P18)) AND (T16._Period = @P19 AND ((T16._Fld10341RRef = @P20)) AND (T16._Fld10346 <> @P21) AND (T16._Fld10346 <> @P22))
  74. GROUP BY T16._Fld10344RRef
  75. HAVING (CAST(SUM(T16._Fld10346) AS NUMERIC(33, 8))) <> 0.0
  76. UNION ALL SELECT
  77. T17._Fld10344RRef AS Fld10344RRef,
  78. CAST(CAST(SUM(CASE WHEN T17._RecordKind = 0.0 THEN -T17._Fld10346 ELSE T17._Fld10346 END) AS NUMERIC(27, 8)) AS NUMERIC(27, 2)) AS Fld10346Balance_
  79. FROM dbo._AccumRg10339 T17
  80. WHERE ((T17._Fld595 = @P23)) AND (T17._Period >= @P24 AND T17._Period < @P25 AND T17._Active = 0x01 AND ((T17._Fld10341RRef = @P26)))
  81. GROUP BY T17._Fld10344RRef
  82. HAVING (CAST(CAST(SUM(CASE WHEN T17._RecordKind = 0.0 THEN -T17._Fld10346 ELSE T17._Fld10346 END) AS NUMERIC(27, 8)) AS NUMERIC(27, 2))) <> 0.0) T15
  83. GROUP BY T15.Fld10344RRef
  84. HAVING (CAST(SUM(T15.Fld10346Balance_) AS NUMERIC(38, 8))) <> 0.0) T14
  85. ON (T1._IDRRef = T14.Fld10344RRef)
  86. LEFT OUTER JOIN dbo._InfoRg9134 T18
  87. ON ((0x08 = T18._Fld9136_TYPE AND 0x000000E9 = T18._Fld9136_RTRef AND T1._IDRRef = T18._Fld9136_RRRef)) AND (T18._Fld595 = @P27)
  88. LEFT OUTER JOIN dbo._InfoRg11720 T19
  89. ON ((0x08 = T19._Fld12312_TYPE AND 0x000000E9 = T19._Fld12312_RTRef AND T1._IDRRef = T19._Fld12312_RRRef)) AND (T19._Fld595 = @P28)
  90. LEFT OUTER JOIN (SELECT
  91. T21._Fld10332_TYPE AS Fld10332_TYPE,
  92. T21._Fld10332_RTRef AS Fld10332_RTRef,
  93. T21._Fld10332_RRRef AS Fld10332_RRRef,
  94. CAST(SUM(T21._Fld10335) AS NUMERIC(33, 8)) AS Fld10335Balance_
  95. FROM dbo._AccumRgT10337 T21
  96. WHERE (((T21._Fld595 = @P29)) AND (EXISTS(SELECT
  97. 1
  98. FROM (SELECT 1 AS SDBL_DUMMY) SDBL_DUAL
  99. LEFT OUTER JOIN dbo._Reference42 T22
  100. ON ((T21._Fld10330RRef = T22._IDRRef)) AND (T22._Fld595 = @P30)
  101. WHERE EXISTS(SELECT
  102. 0x01 AS Q_001_F_000_
  103. FROM dbo._Reference98 T23
  104. INNER JOIN dbo._Reference21 T24
  105. ON (((T23._Fld1685 = @P31) AND EXISTS(SELECT
  106. 0x01 AS Q_004_F_000_
  107. FROM dbo._InfoRg11709 T25
  108. WHERE ((T25._Fld595 = @P32)) AND ((T25._Fld12065RRef = T23._IDRRef) AND (T25._Fld12066RRef = T24._IDRRef)))) AND T24._IDRRef IN
  109. (SELECT
  110. T26._Reference21_IDRRef AS Q_005_F_000RRef
  111. FROM dbo._Reference21_VT782 T26
  112. INNER JOIN dbo._InfoRg9937 T27
  113. ON ((T27._Fld9939_TYPE = 0x08 AND T27._Fld9939_RTRef = 0x00000095 AND T27._Fld9939_RRRef = @P33) AND (T27._Fld9938_TYPE = T26._Fld784_TYPE AND T27._Fld9938_RTRef = T26._Fld784_RTRef AND T27._Fld9938_RRRef = T26._Fld784_RRRef))
  114. WHERE ((T26._Fld595 = @P34)) AND (T27._Fld595 = @P35)))
  115. WHERE ((T24._Fld595 = @P36)) AND ((CASE WHEN T22._Fld12836RRef IS NULL THEN 0x01 ELSE CASE WHEN T22._Fld12836RRef IS NOT NULL THEN 0x08 END END <> 0x01) AND (CASE WHEN EXISTS(SELECT
  116. 0x01 AS Q_002_F_000_
  117. FROM dbo._InfoRg11710 T28
  118. WHERE ((T28._Fld595 = @P37)) AND ((T28._Fld12072RRef = T24._IDRRef) AND (T28._Fld12073_TYPE = CASE WHEN T22._Fld12836RRef IS NOT NULL THEN 0x08 END AND T28._Fld12073_RTRef = CASE WHEN T22._Fld12836RRef IS NOT NULL THEN 0x0000001C END AND T28._Fld12073_RRRef = T22._Fld12836RRef))) THEN 0x01 ELSE 0x00 END = CASE WHEN EXISTS(SELECT
  119. 0x01 AS Q_003_F_000_
  120. FROM dbo._InfoRg11715 T29
  121. WHERE ((T29._Fld595 = @P38)) AND ((T29._Fld12199RRef = T24._IDRRef) AND T29._Fld12200_TYPE = CASE WHEN T22._Fld12836RRef IS NOT NULL THEN 0x08 END AND T29._Fld12200_RTRef = CASE WHEN T22._Fld12836RRef IS NOT NULL THEN 0x0000001C END AND (T29._Fld12201 = 0x00))) THEN 0x01 ELSE 0x00 END)))))) AND (T21._Period = @P39 AND ((T21._Fld10330RRef = @P40)) AND (T21._Fld10335 <> @P41) AND (T21._Fld10335 <> @P42))
  122. GROUP BY T21._Fld10332_TYPE,
  123. T21._Fld10332_RTRef,
  124. T21._Fld10332_RRRef
  125. HAVING (CAST(SUM(T21._Fld10335) AS NUMERIC(33, 8))) <> 0.0) T20
  126. ON (0x08 = T20.Fld10332_TYPE AND 0x000000E9 = T20.Fld10332_RTRef AND T1._IDRRef = T20.Fld10332_RRRef)
  127. LEFT OUTER JOIN (SELECT
  128. T31._Fld14033RRef AS Fld14033RRef,
  129. CAST(SUM(CASE WHEN T31._RecordKind = 0.0 THEN T31._Fld14035 ELSE 0.0 END) AS NUMERIC(26, 8)) AS Fld14035Receipt_,
  130. CAST(SUM(CASE WHEN T31._RecordKind = 0.0 THEN 0.0 ELSE T31._Fld14035 END) AS NUMERIC(26, 8)) AS Fld14035Expense_
  131. FROM dbo._AccumRg14026 T31
  132. WHERE ((T31._Fld595 = @P43)) AND (T31._Active = 0x01 AND ((T31._Fld14031RRef = @P44)))
  133. GROUP BY T31._Fld14033RRef
  134. HAVING (CAST(SUM(CASE WHEN T31._RecordKind = 0.0 THEN T31._Fld14035 ELSE 0.0 END) AS NUMERIC(26, 8))) <> 0.0 OR (CAST(SUM(CASE WHEN T31._RecordKind = 0.0 THEN 0.0 ELSE T31._Fld14035 END) AS NUMERIC(26, 8))) <> 0.0) T30
  135. ON (T30.Fld14033RRef = T1._IDRRef)
  136. LEFT OUTER JOIN dbo._Reference51 T32
  137. ON (T1._Fld4635RRef = T32._IDRRef) AND (T32._Fld595 = @P45)
  138. WHERE (((T1._Fld595 = @P46)) AND (EXISTS(SELECT
  139. 1
  140. FROM (SELECT 1 AS SDBL_DUMMY) SDBL_DUAL
  141. LEFT OUTER JOIN dbo._Reference42 T33
  142. ON ((T1._Fld4625RRef = T33._IDRRef)) AND (T33._Fld595 = @P47)
  143. WHERE EXISTS(SELECT
  144. 0x01 AS Q_001_F_000_
  145. FROM dbo._Reference98 T34
  146. INNER JOIN dbo._Reference21 T35
  147. ON (((T34._Fld1685 = @P48) AND EXISTS(SELECT
  148. 0x01 AS Q_004_F_000_
  149. FROM dbo._InfoRg11709 T36
  150. WHERE ((T36._Fld595 = @P49)) AND ((T36._Fld12065RRef = T34._IDRRef) AND (T36._Fld12066RRef = T35._IDRRef)))) AND T35._IDRRef IN
  151. (SELECT
  152. T37._Reference21_IDRRef AS Q_005_F_000RRef
  153. FROM dbo._Reference21_VT782 T37
  154. INNER JOIN dbo._InfoRg9937 T38
  155. ON ((T38._Fld9939_TYPE = 0x08 AND T38._Fld9939_RTRef = 0x00000095 AND T38._Fld9939_RRRef = @P50) AND (T38._Fld9938_TYPE = T37._Fld784_TYPE AND T38._Fld9938_RTRef = T37._Fld784_RTRef AND T38._Fld9938_RRRef = T37._Fld784_RRRef))
  156. WHERE ((T37._Fld595 = @P51)) AND (T38._Fld595 = @P52)))
  157. WHERE ((T35._Fld595 = @P53)) AND ((CASE WHEN T33._Fld12836RRef IS NULL THEN 0x01 ELSE CASE WHEN T33._Fld12836RRef IS NOT NULL THEN 0x08 END END <> 0x01) AND (CASE WHEN EXISTS(SELECT
  158. 0x01 AS Q_002_F_000_
  159. FROM dbo._InfoRg11710 T39
  160. WHERE ((T39._Fld595 = @P54)) AND ((T39._Fld12072RRef = T35._IDRRef) AND (T39._Fld12073_TYPE = CASE WHEN T33._Fld12836RRef IS NOT NULL THEN 0x08 END AND T39._Fld12073_RTRef = CASE WHEN T33._Fld12836RRef IS NOT NULL THEN 0x0000001C END AND T39._Fld12073_RRRef = T33._Fld12836RRef))) THEN 0x01 ELSE 0x00 END = CASE WHEN EXISTS(SELECT
  161. 0x01 AS Q_003_F_000_
  162. FROM dbo._InfoRg11715 T40
  163. WHERE ((T40._Fld595 = @P55)) AND ((T40._Fld12199RRef = T35._IDRRef) AND T40._Fld12200_TYPE = CASE WHEN T33._Fld12836RRef IS NOT NULL THEN 0x08 END AND T40._Fld12200_RTRef = CASE WHEN T33._Fld12836RRef IS NOT NULL THEN 0x0000001C END AND (T40._Fld12201 = 0x00))) THEN 0x01 ELSE 0x00 END)))))) AND ((T1._Fld4625RRef = @P56) AND (T1._Fld4621RRef = @P57) AND (T1._Date_Time >= @P58) AND (T1._Date_Time <= @P59) AND ((CASE WHEN ((T1._Fld4657RRef = @P60) AND T1._Posted = 0x01) THEN CASE WHEN (ISNULL(CAST(T14.Fld10346Balance_ AS NUMERIC(33, 2)),@P61) > @P62) THEN CASE WHEN (ISNULL(CAST(T2.Fld11330Turnover_ AS NUMERIC(27, 2)),@P63) = ISNULL(CAST(T4.Fld10545Balance_ AS NUMERIC(27, 2)),@P64)) THEN @P65 WHEN ((ISNULL(CAST(T4.Fld10545Balance_ AS NUMERIC(27, 2)),@P66) = @P67) AND (ISNULL(CAST(T2.Fld11330Turnover_ AS NUMERIC(27, 2)),@P68) > @P69)) THEN @P70 WHEN ((CAST(ISNULL(CAST(T2.Fld11330Turnover_ AS NUMERIC(27, 2)),@P71) AS NUMERIC(33, 8)) / @P72) > ISNULL(CAST(T4.Fld10545Balance_ AS NUMERIC(27, 2)),@P73)) THEN @P74 ELSE @P75 END ELSE CASE WHEN (ISNULL(CAST(T2.Fld11330Turnover_ AS NUMERIC(27, 2)),@P76) = ISNULL(CAST(T4.Fld10545Balance_ AS NUMERIC(27, 2)),@P77)) THEN @P78 WHEN ((ISNULL(CAST(T4.Fld10545Balance_ AS NUMERIC(27, 2)),@P79) = @P80) AND (ISNULL(CAST(T2.Fld11330Turnover_ AS NUMERIC(27, 2)),@P81) > @P82)) THEN @P83 WHEN ((CAST(ISNULL(CAST(T2.Fld11330Turnover_ AS NUMERIC(27, 2)),@P84) AS NUMERIC(33, 8)) / @P85) > ISNULL(CAST(T4.Fld10545Balance_ AS NUMERIC(27, 2)),@P86)) THEN @P87 ELSE @P88 END END ELSE @P89 END > @P90) OR ((CASE WHEN ((T1._Fld4657RRef = @P91) AND T1._Posted = 0x01) THEN CASE WHEN (ISNULL(CAST(T14.Fld10346Balance_ AS NUMERIC(33, 2)),@P92) > @P93) THEN CASE WHEN (ISNULL(CAST(T2.Fld11330Turnover_ AS NUMERIC(27, 2)),@P94) = ISNULL(CAST(T4.Fld10545Balance_ AS NUMERIC(27, 2)),@P95)) THEN @P96 WHEN ((ISNULL(CAST(T4.Fld10545Balance_ AS NUMERIC(27, 2)),@P97) = @P98) AND (ISNULL(CAST(T2.Fld11330Turnover_ AS NUMERIC(27, 2)),@P99) > @P100)) THEN @P101 WHEN ((CAST(ISNULL(CAST(T2.Fld11330Turnover_ AS NUMERIC(27, 2)),@P102) AS NUMERIC(33, 8)) / @P103) > ISNULL(CAST(T4.Fld10545Balance_ AS NUMERIC(27, 2)),@P104)) THEN @P105 ELSE @P106 END ELSE CASE WHEN (ISNULL(CAST(T2.Fld11330Turnover_ AS NUMERIC(27, 2)),@P107) = ISNULL(CAST(T4.Fld10545Balance_ AS NUMERIC(27, 2)),@P108)) THEN @P109 WHEN ((ISNULL(CAST(T4.Fld10545Balance_ AS NUMERIC(27, 2)),@P110) = @P111) AND (ISNULL(CAST(T2.Fld11330Turnover_ AS NUMERIC(27, 2)),@P112) > @P113)) THEN @P114 WHEN ((CAST(ISNULL(CAST(T2.Fld11330Turnover_ AS NUMERIC(27, 2)),@P115) AS NUMERIC(33, 8)) / @P116) > ISNULL(CAST(T4.Fld10545Balance_ AS NUMERIC(27, 2)),@P117)) THEN @P118 ELSE @P119 END END ELSE @P120 END = @P121) AND (T1._IDRRef >= @P122))))
  164. ORDER BY (CASE WHEN ((T1._Fld4657RRef = 0xAEB7F7D9237C245A447AADE98F164CDF) AND T1._Posted = 0x01) THEN CASE WHEN (ISNULL(CAST(T14.Fld10346Balance_ AS NUMERIC(33, 2)),0.0) > 0.0) THEN CASE WHEN (ISNULL(CAST(T2.Fld11330Turnover_ AS NUMERIC(27, 2)),0.0) = ISNULL(CAST(T4.Fld10545Balance_ AS NUMERIC(27, 2)),0.0)) THEN 4.0 WHEN ((ISNULL(CAST(T4.Fld10545Balance_ AS NUMERIC(27, 2)),0.0) = 0.0) AND (ISNULL(CAST(T2.Fld11330Turnover_ AS NUMERIC(27, 2)),0.0) > 0.0)) THEN 3.0 WHEN ((CAST(ISNULL(CAST(T2.Fld11330Turnover_ AS NUMERIC(27, 2)),0.0) AS NUMERIC(33, 8)) / 2.0) > ISNULL(CAST(T4.Fld10545Balance_ AS NUMERIC(27, 2)),0.0)) THEN 6.0 ELSE 5.0 END ELSE CASE WHEN (ISNULL(CAST(T2.Fld11330Turnover_ AS NUMERIC(27, 2)),0.0) = ISNULL(CAST(T4.Fld10545Balance_ AS NUMERIC(27, 2)),0.0)) THEN 0.0 WHEN ((ISNULL(CAST(T4.Fld10545Balance_ AS NUMERIC(27, 2)),0.0) = 0.0) AND (ISNULL(CAST(T2.Fld11330Turnover_ AS NUMERIC(27, 2)),0.0) > 0.0)) THEN 3.0 WHEN ((CAST(ISNULL(CAST(T2.Fld11330Turnover_ AS NUMERIC(27, 2)),0.0) AS NUMERIC(33, 8)) / 2.0) > ISNULL(CAST(T4.Fld10545Balance_ AS NUMERIC(27, 2)),0.0)) THEN 2.0 ELSE 1.0 END END ELSE 7.0 END), (T1._IDRRef)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement