API tools faq
paste
bytecoded

Top 2 Query SQL

bytecoded
Mar 23rd, 2019
367
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 9.36 KB | None | 0 0
raw download clone embed print report
  1. (@P1 NUMERIC(10),@P2 NUMERIC(10),@P3 NUMERIC(10),@P4 datetime2(3),@P5 NUMERIC(10),@P6 NUMERIC(10),@P7 NUMERIC(10),@P8 datetime2(3),@P9 NUMERIC(10),@P10 NUMERIC(10),@P11 NUMERIC(10),@P12 datetime2(3),@P13 datetime2(3),@P14 NUMERIC(10),@P15 NUMERIC(10),@P16 NUMERIC(10),@P17 datetime2(3),@P18 NUMERIC(10),@P19 NUMERIC(10),@P20 NUMERIC(10),@P21 NUMERIC(10),@P22 varbinary(16),@P23 varbinary(16),@P24 NUMERIC(10),@P25 NUMERIC(10),@P26 NUMERIC(10),@P27 NUMERIC(10),@P28 NUMERIC(10),@P29 NUMERIC(10),@P30 NUMERIC(10),@P31 NUMERIC(10),@P32 NUMERIC(10),@P33 NUMERIC(10),@P34 NUMERIC(10),@P35 NUMERIC(10),@P36 NUMERIC(10),@P37 NUMERIC(10),@P38 NUMERIC(10),@P39 NUMERIC(10),@P40 NUMERIC(10),@P41 NUMERIC(10),@P42 NUMERIC(10),@P43 NUMERIC(10),@P44 NUMERIC(10),@P45 NUMERIC(10),@P46 NUMERIC(10),@P47 NUMERIC(10),@P48 NUMERIC(10),@P49 NUMERIC(10),@P50 NUMERIC(10),@P51 NUMERIC(10),@P52 NUMERIC(10),@P53 NUMERIC(10),@P54 varbinary(16),@P55 NUMERIC(10),@P56 NUMERIC(10),@P57 NUMERIC(10),@P58 NUMERIC(10),@P59 NUMERIC(10),@P60 NUMERIC(10),@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 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._Fld4633,
  11. T1._Fld4635RRef,
  12. T1._Fld4657RRef,
  13. CASE WHEN ((T1._Fld4657RRef = 0xAEB7F7D9237C245A447AADE98F164CDF) AND T1._Posted = 0x01) THEN CASE WHEN (ISNULL(CAST(T6.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,
  14. T11._Fld12313RRef,
  15. CASE WHEN ((ISNULL(CAST(T12.Fld10335Balance_ AS NUMERIC(27, 2)),0.0) + ISNULL(CAST(T4.Fld10545Balance_ AS NUMERIC(27, 2)),0.0)) > 0.0) THEN (ISNULL(CAST(T12.Fld10335Balance_ AS NUMERIC(27, 2)),0.0) + ISNULL(CAST(T4.Fld10545Balance_ AS NUMERIC(27, 2)),0.0)) ELSE 0.0 END,
  16. T14._Fld1191
  17. FROM dbo._Document233 T1
  18. LEFT OUTER JOIN (SELECT
  19. T3._Fld11328RRef AS Fld11328RRef,
  20. CAST(SUM(T3._Fld11330) AS NUMERIC(33, 8)) AS Fld11330Turnover_
  21. FROM dbo._AccumRgTn11332 T3
  22. WHERE ((T3._Fld595 = @P1)) AND ((T3._Fld11330 <> @P2))
  23. GROUP BY T3._Fld11328RRef
  24. HAVING (CAST(SUM(T3._Fld11330) AS NUMERIC(33, 8))) <> 0.0) T2
  25. ON (T1._IDRRef = T2.Fld11328RRef)
  26. LEFT OUTER JOIN (SELECT
  27. T5._Fld10540_TYPE AS Fld10540_TYPE,
  28. T5._Fld10540_RTRef AS Fld10540_RTRef,
  29. T5._Fld10540_RRRef AS Fld10540_RRRef,
  30. CAST(SUM(T5._Fld10545) AS NUMERIC(33, 8)) AS Fld10545Balance_
  31. FROM dbo._AccumRgT10549 T5
  32. WHERE ((T5._Fld595 = @P3)) AND (T5._Period = @P4 AND (T5._Fld10545 <> @P5) AND (T5._Fld10545 <> @P6))
  33. GROUP BY T5._Fld10540_TYPE,
  34. T5._Fld10540_RTRef,
  35. T5._Fld10540_RRRef
  36. HAVING (CAST(SUM(T5._Fld10545) AS NUMERIC(33, 8))) <> 0.0) T4
  37. ON (0x08 = T4.Fld10540_TYPE AND 0x000000E9 = T4.Fld10540_RTRef AND T1._IDRRef = T4.Fld10540_RRRef)
  38. LEFT OUTER JOIN (SELECT
  39. T7.Fld10344RRef AS Fld10344RRef,
  40. CAST(SUM(T7.Fld10346Balance_) AS NUMERIC(38, 8)) AS Fld10346Balance_
  41. FROM (SELECT
  42. T8._Fld10344RRef AS Fld10344RRef,
  43. CAST(SUM(T8._Fld10346) AS NUMERIC(33, 8)) AS Fld10346Balance_
  44. FROM dbo._AccumRgT10349 T8
  45. WHERE ((T8._Fld595 = @P7)) AND (T8._Period = @P8 AND (T8._Fld10346 <> @P9) AND (T8._Fld10346 <> @P10))
  46. GROUP BY T8._Fld10344RRef
  47. HAVING (CAST(SUM(T8._Fld10346) AS NUMERIC(33, 8))) <> 0.0
  48. UNION ALL SELECT
  49. T9._Fld10344RRef AS Fld10344RRef,
  50. CAST(CAST(SUM(CASE WHEN T9._RecordKind = 0.0 THEN -T9._Fld10346 ELSE T9._Fld10346 END) AS NUMERIC(27, 8)) AS NUMERIC(27, 2)) AS Fld10346Balance_
  51. FROM dbo._AccumRg10339 T9
  52. WHERE ((T9._Fld595 = @P11)) AND (T9._Period >= @P12 AND T9._Period < @P13 AND T9._Active = 0x01)
  53. GROUP BY T9._Fld10344RRef
  54. HAVING (CAST(CAST(SUM(CASE WHEN T9._RecordKind = 0.0 THEN -T9._Fld10346 ELSE T9._Fld10346 END) AS NUMERIC(27, 8)) AS NUMERIC(27, 2))) <> 0.0) T7
  55. GROUP BY T7.Fld10344RRef
  56. HAVING (CAST(SUM(T7.Fld10346Balance_) AS NUMERIC(38, 8))) <> 0.0) T6
  57. ON (T1._IDRRef = T6.Fld10344RRef)
  58. LEFT OUTER JOIN dbo._InfoRg9134 T10
  59. ON ((0x08 = T10._Fld9136_TYPE AND 0x000000E9 = T10._Fld9136_RTRef AND T1._IDRRef = T10._Fld9136_RRRef)) AND (T10._Fld595 = @P14)
  60. LEFT OUTER JOIN dbo._InfoRg11720 T11
  61. ON ((0x08 = T11._Fld12312_TYPE AND 0x000000E9 = T11._Fld12312_RTRef AND T1._IDRRef = T11._Fld12312_RRRef)) AND (T11._Fld595 = @P15)
  62. LEFT OUTER JOIN (SELECT
  63. T13._Fld10332_TYPE AS Fld10332_TYPE,
  64. T13._Fld10332_RTRef AS Fld10332_RTRef,
  65. T13._Fld10332_RRRef AS Fld10332_RRRef,
  66. CAST(SUM(T13._Fld10335) AS NUMERIC(33, 8)) AS Fld10335Balance_
  67. FROM dbo._AccumRgT10337 T13
  68. WHERE ((T13._Fld595 = @P16)) AND (T13._Period = @P17 AND (T13._Fld10335 <> @P18) AND (T13._Fld10335 <> @P19))
  69. GROUP BY T13._Fld10332_TYPE,
  70. T13._Fld10332_RTRef,
  71. T13._Fld10332_RRRef
  72. HAVING (CAST(SUM(T13._Fld10335) AS NUMERIC(33, 8))) <> 0.0) T12
  73. ON (0x08 = T12.Fld10332_TYPE AND 0x000000E9 = T12.Fld10332_RTRef AND T1._IDRRef = T12.Fld10332_RRRef)
  74. LEFT OUTER JOIN dbo._Reference51 T14
  75. ON (T1._Fld4635RRef = T14._IDRRef) AND (T14._Fld595 = @P20)
  76. WHERE ((T1._Fld595 = @P21)) AND ((T1._Fld4621RRef = @P22) AND ((CASE WHEN ((T1._Fld4657RRef = @P23) AND T1._Posted = 0x01) THEN CASE WHEN (ISNULL(CAST(T6.Fld10346Balance_ AS NUMERIC(33, 2)),@P24) > @P25) THEN CASE WHEN (ISNULL(CAST(T2.Fld11330Turnover_ AS NUMERIC(27, 2)),@P26) = ISNULL(CAST(T4.Fld10545Balance_ AS NUMERIC(27, 2)),@P27)) THEN @P28 WHEN ((ISNULL(CAST(T4.Fld10545Balance_ AS NUMERIC(27, 2)),@P29) = @P30) AND (ISNULL(CAST(T2.Fld11330Turnover_ AS NUMERIC(27, 2)),@P31) > @P32)) THEN @P33 WHEN ((CAST(ISNULL(CAST(T2.Fld11330Turnover_ AS NUMERIC(27, 2)),@P34) AS NUMERIC(33, 8)) / @P35) > ISNULL(CAST(T4.Fld10545Balance_ AS NUMERIC(27, 2)),@P36)) THEN @P37 ELSE @P38 END ELSE CASE WHEN (ISNULL(CAST(T2.Fld11330Turnover_ AS NUMERIC(27, 2)),@P39) = ISNULL(CAST(T4.Fld10545Balance_ AS NUMERIC(27, 2)),@P40)) THEN @P41 WHEN ((ISNULL(CAST(T4.Fld10545Balance_ AS NUMERIC(27, 2)),@P42) = @P43) AND (ISNULL(CAST(T2.Fld11330Turnover_ AS NUMERIC(27, 2)),@P44) > @P45)) THEN @P46 WHEN ((CAST(ISNULL(CAST(T2.Fld11330Turnover_ AS NUMERIC(27, 2)),@P47) AS NUMERIC(33, 8)) / @P48) > ISNULL(CAST(T4.Fld10545Balance_ AS NUMERIC(27, 2)),@P49)) THEN @P50 ELSE @P51 END END ELSE @P52 END > @P53) OR ((CASE WHEN ((T1._Fld4657RRef = @P54) AND T1._Posted = 0x01) THEN CASE WHEN (ISNULL(CAST(T6.Fld10346Balance_ AS NUMERIC(33, 2)),@P55) > @P56) THEN CASE WHEN (ISNULL(CAST(T2.Fld11330Turnover_ AS NUMERIC(27, 2)),@P57) = ISNULL(CAST(T4.Fld10545Balance_ AS NUMERIC(27, 2)),@P58)) THEN @P59 WHEN ((ISNULL(CAST(T4.Fld10545Balance_ AS NUMERIC(27, 2)),@P60) = @P61) AND (ISNULL(CAST(T2.Fld11330Turnover_ AS NUMERIC(27, 2)),@P62) > @P63)) THEN @P64 WHEN ((CAST(ISNULL(CAST(T2.Fld11330Turnover_ AS NUMERIC(27, 2)),@P65) AS NUMERIC(33, 8)) / @P66) > ISNULL(CAST(T4.Fld10545Balance_ AS NUMERIC(27, 2)),@P67)) THEN @P68 ELSE @P69 END ELSE CASE WHEN (ISNULL(CAST(T2.Fld11330Turnover_ AS NUMERIC(27, 2)),@P70) = ISNULL(CAST(T4.Fld10545Balance_ AS NUMERIC(27, 2)),@P71)) THEN @P72 WHEN ((ISNULL(CAST(T4.Fld10545Balance_ AS NUMERIC(27, 2)),@P73) = @P74) AND (ISNULL(CAST(T2.Fld11330Turnover_ AS NUMERIC(27, 2)),@P75) > @P76)) THEN @P77 WHEN ((CAST(ISNULL(CAST(T2.Fld11330Turnover_ AS NUMERIC(27, 2)),@P78) AS NUMERIC(33, 8)) / @P79) > ISNULL(CAST(T4.Fld10545Balance_ AS NUMERIC(27, 2)),@P80)) THEN @P81 ELSE @P82 END END ELSE @P83 END = @P84) AND (T1._IDRRef >= @P85))))
  77. ORDER BY (CASE WHEN ((T1._Fld4657RRef = 0xAEB7F7D9237C245A447AADE98F164CDF) AND T1._Posted = 0x01) THEN CASE WHEN (ISNULL(CAST(T6.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)
Add Comment
Please, Sign In to add comment
Public Pastes
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!