API tools faq
paste
Advertisement
bytecoded

Most Costly Query by CPU (1)

bytecoded
Oct 29th, 2019
401
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 17.04 KB | None | 0 0
raw download clone embed print report
  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) DESC, (T1._IDRRef) DESC
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!