Top 4 Query SQL

(@P1 varbinary(16),@P2 NUMERIC(10),@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 NUMERIC(10),@P16 NUMERIC(10),@P17 NUMERIC(10),@P18 datetime2(3),@P19 NUMERIC(10),@P20 NUMERIC(10),@P21 NUMERIC(10),@P22 datetime2(3),@P23 datetime2(3),@P24 NUMERIC(10),@P25 NUMERIC(10),@P26 NUMERIC(10),@P27 NUMERIC(10),@P28 nvarchar(4000),@P29 NUMERIC(10),@P30 varbinary(16),@P31 NUMERIC(10),@P32 NUMERIC(10),@P33 NUMERIC(10),@P34 NUMERIC(10),@P35 NUMERIC(10),@P36 datetime2(3),@P37 NUMERIC(10),@P38 NUMERIC(10),@P39 NUMERIC(10),@P40 NUMERIC(10),@P41 NUMERIC(10),@P42 nvarchar(4000),@P43 NUMERIC(10),@P44 varbinary(16),@P45 NUMERIC(10),@P46 NUMERIC(10),@P47 NUMERIC(10),@P48 NUMERIC(10),@P49 NUMERIC(10),@P50 varbinary(16),@P51 datetime2(3))SELECT TOP 25
T39._IDRRef,
T39._Marked,
T39._Number,
T39._Date_Time,
T39._Posted,
T39._Fld4621RRef,
T39._Fld4622RRef,
T39._Fld4625RRef,
T39._Fld4633,
T39._Fld4635RRef,
T39._Fld4654RRef,
T39._Fld4657RRef,
CASE WHEN ((T39._Fld4657RRef = @P1) AND T39._Posted = 0x01) THEN CASE WHEN (ISNULL(CAST(T52.Fld10346Balance_ AS NUMERIC(33, 2)),0.0) > 0.0) THEN CASE WHEN (ISNULL(CAST(T40.Fld11330Turnover_ AS NUMERIC(27, 2)),0.0) = ISNULL(CAST(T42.Fld10545Balance_ AS NUMERIC(27, 2)),0.0)) THEN 4.0 WHEN ((ISNULL(CAST(T42.Fld10545Balance_ AS NUMERIC(27, 2)),0.0) = 0.0) AND (ISNULL(CAST(T40.Fld11330Turnover_ AS NUMERIC(27, 2)),0.0) > 0.0)) THEN 3.0 WHEN ((CAST(ISNULL(CAST(T40.Fld11330Turnover_ AS NUMERIC(27, 2)),0.0) AS NUMERIC(33, 8)) / 2.0) > ISNULL(CAST(T42.Fld10545Balance_ AS NUMERIC(27, 2)),0.0)) THEN 6.0 ELSE 5.0 END ELSE CASE WHEN (ISNULL(CAST(T40.Fld11330Turnover_ AS NUMERIC(27, 2)),0.0) = ISNULL(CAST(T42.Fld10545Balance_ AS NUMERIC(27, 2)),0.0)) THEN 0.0 WHEN ((ISNULL(CAST(T42.Fld10545Balance_ AS NUMERIC(27, 2)),0.0) = 0.0) AND (ISNULL(CAST(T40.Fld11330Turnover_ AS NUMERIC(27, 2)),0.0) > 0.0)) THEN 3.0 WHEN ((CAST(ISNULL(CAST(T40.Fld11330Turnover_ AS NUMERIC(27, 2)),0.0) AS NUMERIC(33, 8)) / 2.0) > ISNULL(CAST(T42.Fld10545Balance_ AS NUMERIC(27, 2)),0.0)) THEN 2.0 ELSE 1.0 END END ELSE 7.0 END,
T57._Fld12313RRef,
CASE WHEN ((ISNULL(CAST(T58.Fld10335Balance_ AS NUMERIC(27, 2)),0.0) + ISNULL(CAST(T42.Fld10545Balance_ AS NUMERIC(27, 2)),0.0)) > 0.0) THEN (ISNULL(CAST(T58.Fld10335Balance_ AS NUMERIC(27, 2)),0.0) + ISNULL(CAST(T42.Fld10545Balance_ AS NUMERIC(27, 2)),0.0)) ELSE 0.0 END,
T68._Fld1191
FROM dbo._Document233 T39
LEFT OUTER JOIN (SELECT
T41._Fld11328RRef AS Fld11328RRef,
CAST(SUM(T41._Fld11330) AS NUMERIC(33, 8)) AS Fld11330Turnover_
FROM dbo._AccumRgTn11332 T41
WHERE ((T41._Fld595 = @P2)) AND ((T41._Fld11330 <> @P3))
GROUP BY T41._Fld11328RRef
HAVING (CAST(SUM(T41._Fld11330) AS NUMERIC(33, 8))) <> 0.0) T40
ON (T39._IDRRef = T40.Fld11328RRef)
LEFT OUTER JOIN (SELECT
T43._Fld10540_TYPE AS Fld10540_TYPE,
T43._Fld10540_RTRef AS Fld10540_RTRef,
T43._Fld10540_RRRef AS Fld10540_RRRef,
CAST(SUM(T43._Fld10545) AS NUMERIC(33, 8)) AS Fld10545Balance_
FROM dbo._AccumRgT10549 T43
WHERE (((T43._Fld595 = @P4)) AND (EXISTS(SELECT
1
FROM (SELECT 1 AS SDBL_DUMMY) SDBL_DUAL
LEFT OUTER JOIN dbo._Reference42 T44
ON ((T43._Fld10538RRef = T44._IDRRef)) AND (T44._Fld595 = @P5)
WHERE EXISTS(SELECT
0x01 AS Q_001_F_000_
FROM dbo._Reference98 T45
INNER JOIN dbo._Reference21 T46
ON (((T45._Fld1685 = @P6) AND EXISTS(SELECT
0x01 AS Q_004_F_000_
FROM dbo._InfoRg11709 T47
WHERE ((T47._Fld595 = @P7)) AND ((T47._Fld12065RRef = T45._IDRRef) AND (T47._Fld12066RRef = T46._IDRRef)))) AND T46._IDRRef IN
(SELECT
T48._Reference21_IDRRef AS Q_005_F_000RRef
FROM dbo._Reference21_VT782 T48
INNER JOIN dbo._InfoRg9937 T49
ON ((T49._Fld9939_TYPE = 0x08 AND T49._Fld9939_RTRef = 0x00000095 AND T49._Fld9939_RRRef = @P8) AND (T49._Fld9938_TYPE = T48._Fld784_TYPE AND T49._Fld9938_RTRef = T48._Fld784_RTRef AND T49._Fld9938_RRRef = T48._Fld784_RRRef))
WHERE ((T48._Fld595 = @P9)) AND (T49._Fld595 = @P10)))
WHERE ((T46._Fld595 = @P11)) AND ((CASE WHEN T44._Fld12836RRef IS NULL THEN 0x01 ELSE CASE WHEN T44._Fld12836RRef IS NOT NULL THEN 0x08 END END <> 0x01) AND (CASE WHEN EXISTS(SELECT
0x01 AS Q_002_F_000_
FROM dbo._InfoRg11710 T50
WHERE ((T50._Fld595 = @P12)) AND ((T50._Fld12072RRef = T46._IDRRef) AND (T50._Fld12073_TYPE = CASE WHEN T44._Fld12836RRef IS NOT NULL THEN 0x08 END AND T50._Fld12073_RTRef = CASE WHEN T44._Fld12836RRef IS NOT NULL THEN 0x0000001C END AND T50._Fld12073_RRRef = T44._Fld12836RRef))) THEN 0x01 ELSE 0x00 END = CASE WHEN EXISTS(SELECT
0x01 AS Q_003_F_000_
FROM dbo._InfoRg11715 T51
WHERE ((T51._Fld595 = @P13)) AND ((T51._Fld12199RRef = T46._IDRRef) AND T51._Fld12200_TYPE = CASE WHEN T44._Fld12836RRef IS NOT NULL THEN 0x08 END AND T51._Fld12200_RTRef = CASE WHEN T44._Fld12836RRef IS NOT NULL THEN 0x0000001C END AND (T51._Fld12201 = 0x00))) THEN 0x01 ELSE 0x00 END)))))) AND (T43._Period = @P14 AND (T43._Fld10545 <> @P15) AND (T43._Fld10545 <> @P16))
GROUP BY T43._Fld10540_TYPE,
T43._Fld10540_RTRef,
T43._Fld10540_RRRef
HAVING (CAST(SUM(T43._Fld10545) AS NUMERIC(33, 8))) <> 0.0) T42
ON (0x08 = T42.Fld10540_TYPE AND 0x000000E9 = T42.Fld10540_RTRef AND T39._IDRRef = T42.Fld10540_RRRef)
LEFT OUTER JOIN (SELECT
T53.Fld10344RRef AS Fld10344RRef,
CAST(SUM(T53.Fld10346Balance_) AS NUMERIC(38, 8)) AS Fld10346Balance_
FROM (SELECT
T54._Fld10344RRef AS Fld10344RRef,
CAST(SUM(T54._Fld10346) AS NUMERIC(33, 8)) AS Fld10346Balance_
FROM dbo._AccumRgT10349 T54
WHERE ((T54._Fld595 = @P17)) AND (T54._Period = @P18 AND (T54._Fld10346 <> @P19) AND (T54._Fld10346 <> @P20))
GROUP BY T54._Fld10344RRef
HAVING (CAST(SUM(T54._Fld10346) AS NUMERIC(33, 8))) <> 0.0
UNION ALL SELECT
T55._Fld10344RRef AS Fld10344RRef,
CAST(CAST(SUM(CASE WHEN T55._RecordKind = 0.0 THEN -T55._Fld10346 ELSE T55._Fld10346 END) AS NUMERIC(27, 8)) AS NUMERIC(27, 2)) AS Fld10346Balance_
FROM dbo._AccumRg10339 T55
WHERE ((T55._Fld595 = @P21)) AND (T55._Period >= @P22 AND T55._Period < @P23 AND T55._Active = 0x01)
GROUP BY T55._Fld10344RRef
HAVING (CAST(CAST(SUM(CASE WHEN T55._RecordKind = 0.0 THEN -T55._Fld10346 ELSE T55._Fld10346 END) AS NUMERIC(27, 8)) AS NUMERIC(27, 2))) <> 0.0) T53
GROUP BY T53.Fld10344RRef
HAVING (CAST(SUM(T53.Fld10346Balance_) AS NUMERIC(38, 8))) <> 0.0) T52
ON (T39._IDRRef = T52.Fld10344RRef)
LEFT OUTER JOIN dbo._InfoRg9134 T56
ON ((0x08 = T56._Fld9136_TYPE AND 0x000000E9 = T56._Fld9136_RTRef AND T39._IDRRef = T56._Fld9136_RRRef)) AND (T56._Fld595 = @P24)
LEFT OUTER JOIN dbo._InfoRg11720 T57
ON ((0x08 = T57._Fld12312_TYPE AND 0x000000E9 = T57._Fld12312_RTRef AND T39._IDRRef = T57._Fld12312_RRRef)) AND (T57._Fld595 = @P25)
LEFT OUTER JOIN (SELECT
T59._Fld10332_TYPE AS Fld10332_TYPE,
T59._Fld10332_RTRef AS Fld10332_RTRef,
T59._Fld10332_RRRef AS Fld10332_RRRef,
CAST(SUM(T59._Fld10335) AS NUMERIC(33, 8)) AS Fld10335Balance_
FROM dbo._AccumRgT10337 T59
WHERE (((T59._Fld595 = @P26)) AND (EXISTS(SELECT
1
FROM (SELECT 1 AS SDBL_DUMMY) SDBL_DUAL
LEFT OUTER JOIN dbo._Reference42 T60
ON ((T59._Fld10330RRef = T60._IDRRef)) AND (T60._Fld595 = @P27)
WHERE EXISTS(SELECT
0x01 AS Q_001_F_000_
FROM dbo._Reference98 T61
INNER JOIN dbo._Reference21 T62
ON (((T61._Fld1685 = @P28) AND EXISTS(SELECT
0x01 AS Q_004_F_000_
FROM dbo._InfoRg11709 T63
WHERE ((T63._Fld595 = @P29)) AND ((T63._Fld12065RRef = T61._IDRRef) AND (T63._Fld12066RRef = T62._IDRRef)))) AND T62._IDRRef IN
(SELECT
T64._Reference21_IDRRef AS Q_005_F_000RRef
FROM dbo._Reference21_VT782 T64
INNER JOIN dbo._InfoRg9937 T65
ON ((T65._Fld9939_TYPE = 0x08 AND T65._Fld9939_RTRef = 0x00000095 AND T65._Fld9939_RRRef = @P30) AND (T65._Fld9938_TYPE = T64._Fld784_TYPE AND T65._Fld9938_RTRef = T64._Fld784_RTRef AND T65._Fld9938_RRRef = T64._Fld784_RRRef))
WHERE ((T64._Fld595 = @P31)) AND (T65._Fld595 = @P32)))
WHERE ((T62._Fld595 = @P33)) AND ((CASE WHEN T60._Fld12836RRef IS NULL THEN 0x01 ELSE CASE WHEN T60._Fld12836RRef IS NOT NULL THEN 0x08 END END <> 0x01) AND (CASE WHEN EXISTS(SELECT
0x01 AS Q_002_F_000_
FROM dbo._InfoRg11710 T66
WHERE ((T66._Fld595 = @P34)) AND ((T66._Fld12072RRef = T62._IDRRef) AND (T66._Fld12073_TYPE = CASE WHEN T60._Fld12836RRef IS NOT NULL THEN 0x08 END AND T66._Fld12073_RTRef = CASE WHEN T60._Fld12836RRef IS NOT NULL THEN 0x0000001C END AND T66._Fld12073_RRRef = T60._Fld12836RRef))) THEN 0x01 ELSE 0x00 END = CASE WHEN EXISTS(SELECT
0x01 AS Q_003_F_000_
FROM dbo._InfoRg11715 T67
WHERE ((T67._Fld595 = @P35)) AND ((T67._Fld12199RRef = T62._IDRRef) AND T67._Fld12200_TYPE = CASE WHEN T60._Fld12836RRef IS NOT NULL THEN 0x08 END AND T67._Fld12200_RTRef = CASE WHEN T60._Fld12836RRef IS NOT NULL THEN 0x0000001C END AND (T67._Fld12201 = 0x00))) THEN 0x01 ELSE 0x00 END)))))) AND (T59._Period = @P36 AND (T59._Fld10335 <> @P37) AND (T59._Fld10335 <> @P38))
GROUP BY T59._Fld10332_TYPE,
T59._Fld10332_RTRef,
T59._Fld10332_RRRef
HAVING (CAST(SUM(T59._Fld10335) AS NUMERIC(33, 8))) <> 0.0) T58
ON (0x08 = T58.Fld10332_TYPE AND 0x000000E9 = T58.Fld10332_RTRef AND T39._IDRRef = T58.Fld10332_RRRef)
LEFT OUTER JOIN dbo._Reference51 T68
ON (T39._Fld4635RRef = T68._IDRRef) AND (T68._Fld595 = @P39)
WHERE (((((T39._Fld595 = @P40) AND (EXISTS(SELECT
1
FROM (SELECT 1 AS SDBL_DUMMY) SDBL_DUAL
LEFT OUTER JOIN dbo._Reference42 T69
ON ((T39._Fld4625RRef = T69._IDRRef)) AND (T69._Fld595 = @P41)
WHERE EXISTS(SELECT
0x01 AS Q_001_F_000_
FROM dbo._Reference98 T70
INNER JOIN dbo._Reference21 T71
ON (((T70._Fld1685 = @P42) AND EXISTS(SELECT
0x01 AS Q_004_F_000_
FROM dbo._InfoRg11709 T72
WHERE ((T72._Fld595 = @P43)) AND ((T72._Fld12065RRef = T70._IDRRef) AND (T72._Fld12066RRef = T71._IDRRef)))) AND T71._IDRRef IN
(SELECT
T73._Reference21_IDRRef AS Q_005_F_000RRef
FROM dbo._Reference21_VT782 T73
INNER JOIN dbo._InfoRg9937 T74
ON ((T74._Fld9939_TYPE = 0x08 AND T74._Fld9939_RTRef = 0x00000095 AND T74._Fld9939_RRRef = @P44) AND (T74._Fld9938_TYPE = T73._Fld784_TYPE AND T74._Fld9938_RTRef = T73._Fld784_RTRef AND T74._Fld9938_RRRef = T73._Fld784_RRRef))
WHERE ((T73._Fld595 = @P45)) AND (T74._Fld595 = @P46)))
WHERE ((T71._Fld595 = @P47)) AND ((CASE WHEN T69._Fld12836RRef IS NULL THEN 0x01 ELSE CASE WHEN T69._Fld12836RRef IS NOT NULL THEN 0x08 END END <> 0x01) AND (CASE WHEN EXISTS(SELECT
0x01 AS Q_002_F_000_
FROM dbo._InfoRg11710 T75
WHERE ((T75._Fld595 = @P48)) AND ((T75._Fld12072RRef = T71._IDRRef) AND (T75._Fld12073_TYPE = CASE WHEN T69._Fld12836RRef IS NOT NULL THEN 0x08 END AND T75._Fld12073_RTRef = CASE WHEN T69._Fld12836RRef IS NOT NULL THEN 0x0000001C END AND T75._Fld12073_RRRef = T69._Fld12836RRef))) THEN 0x01 ELSE 0x00 END = CASE WHEN EXISTS(SELECT
0x01 AS Q_003_F_000_
FROM dbo._InfoRg11715 T76
WHERE ((T76._Fld595 = @P49)) AND ((T76._Fld12199RRef = T71._IDRRef) AND T76._Fld12200_TYPE = CASE WHEN T69._Fld12836RRef IS NOT NULL THEN 0x08 END AND T76._Fld12200_RTRef = CASE WHEN T69._Fld12836RRef IS NOT NULL THEN 0x0000001C END AND (T76._Fld12201 = 0x00))) THEN 0x01 ELSE 0x00 END)))))) AND (T39._Fld4621RRef = @P50)) AND (T39._Posted = 0x00)) AND (T39._Marked = 0x00)) AND T39._Date_Time > @P51
ORDER BY (T39._Date_Time), (T39._IDRRef)
OPTION (FAST 1)