ЗапросПоУпаковкам

EXEC sp_executesql N'SELECT
T2._IDRRef,
(CAST(T2._Fld7360 AS NUMERIC(20, 8)) / T2._Fld7361),
T2._ParentIDRRef
FROM dbo._Reference165 T1
INNER JOIN dbo._Reference294 T2
ON (T2._OwnerID_TYPE = CASE WHEN (T1._Fld4088RRef = @P1) THEN 0x08 WHEN (T1._Fld4088RRef <> @P2) THEN CASE WHEN T1._Fld4088RRef IS NOT NULL THEN 0x08 END ELSE 0x02 END AND 0x00 = CASE WHEN (T1._Fld4088RRef = @P3) THEN 0x00 WHEN (T1._Fld4088RRef <> @P4) THEN CASE WHEN T1._Fld4088RRef IS NOT NULL THEN 0x00 END ELSE 0x00 END AND T2._OwnerID_RTRef = CASE WHEN (T1._Fld4088RRef = @P5) THEN 0x000000A5 WHEN (T1._Fld4088RRef <> @P6) THEN CASE WHEN T1._Fld4088RRef IS NOT NULL THEN 0x0000009D END ELSE 0x00000000 END AND T2._OwnerID_RRRef = CASE WHEN (T1._Fld4088RRef = @P7) THEN T1._IDRRef WHEN (T1._Fld4088RRef <> @P8) THEN T1._Fld4088RRef ELSE @P9 END)
WHERE (((T1._Fld839 = @P10)) AND (T2._Fld839 = @P11)) AND ((T1._IDRRef = @P12) AND (T2._Marked = 0x00))
ORDER BY (T2._ParentIDRRef), (T2._IDRRef)',N'@P1 varbinary(16),@P2 varbinary(16),@P3 varbinary(16),@P4 varbinary(16),@P5 varbinary(16),@P6 varbinary(16),@P7 varbinary(16),@P8 varbinary(16),@P9 varbinary(16),@P10 numeric(10),@P11 numeric(10),@P12 varbinary(16)',0x864208606E83405811E5B2ED37B54C1A,0x00000000000000000000000000000000,0x864208606E83405811E5B2ED37B54C1A,0x00000000000000000000000000000000,0x864208606E83405811E5B2ED37B54C1A,0x00000000000000000000000000000000,0x864208606E83405811E5B2ED37B54C1A,0x00000000000000000000000000000000,0x00000000000000000000000000000000,0,0,0x864208606E83405811E5B2F3029EE8A6