Код: Выделить всё
SELECT V_S_1_2_3.ID_Klient, V_S_1_2_3.KlientName, V_S_1_2_3.CityName,
V_S_1_2_3.ID_Country, V_S_1_2_3.Saldo0, V_S_1_2_3.OborOtgr, V_S_1_2_3.OborOpl,
V_S_1_2_3.Saldo1, V_S_1_2_3.Saldo0Kt, V_S_1_2_3.Saldo0Dt, V_S_1_2_3.Saldo1Kt,
V_S_1_2_3.Saldo1Dt, V_S_1_2_3.CountryName, V_S_1_2_3.ID_Region,
V_S_1_2_3.RegionName, V_S_1_2_3.Val, V_S_1_2_3.UIN
FROM (SELECT Klient.ID_Klient, Klient.KlientName, City.CityName,
City.ID_Country, ISNULL(V_S1_Opl.SumOpl1, 0) - ISNULL(V_S3_Otgr.SumNak3,
0) AS Saldo0, CASE WHEN ISNULL(V_S2_Otgr.CodePlat, 0) = 0 THEN 0
ELSE V_S2_Otgr.SumNak END AS OborOtgr, CASE
WHEN ISNULL(V_S2_Opl.KodPolOpl, 0) = 0 THEN 0 ELSE V_S2_Opl.SumOpl2
END AS OborOpl, (ISNULL(V_S1_Opl.SumOpl1, 0) - ISNULL(V_S3_Otgr.SumNak3,
0)) - (CASE WHEN ISNULL(V_S2_Otgr.CodePlat, 0) = 0 THEN 0
ELSE V_S2_Otgr.SumNak END) + (CASE
WHEN ISNULL(V_S2_Opl.KodPolOpl, 0) = 0 THEN 0 ELSE V_S2_Opl.SumOpl2
END) AS Saldo1, CASE
WHEN ISNULL(V_S1_Opl.SumOpl1, 0) - ISNULL(V_S3_Otgr.SumNak3, 0) >
0 THEN ISNULL(V_S1_Opl.SumOpl1, 0) - ISNULL(V_S3_Otgr.SumNak3, 0) ELSE 0
END AS Saldo0Kt, CASE
WHEN ISNULL(V_S1_Opl.SumOpl1, 0) - ISNULL(V_S3_Otgr.SumNak3, 0) 0 THEN (ISNULL(V_S1_Opl.SumOpl1, 0) - ISNULL(V_S3_Otgr.SumNak3,
0)) - (CASE WHEN ISNULL(V_S2_Otgr.CodePlat, 0) = 0 THEN 0
ELSE V_S2_Otgr.SumNak END) + (CASE
WHEN ISNULL(V_S2_Opl.KodPolOpl, 0) = 0 THEN 0 ELSE V_S2_Opl.SumOpl2
END) ELSE 0 END AS Saldo1Kt, CASE
WHEN (ISNULL(V_S1_Opl.SumOpl1, 0) - ISNULL(V_S3_Otgr.SumNak3, 0)) -
(CASE WHEN ISNULL(V_S2_Otgr.CodePlat, 0) = 0 THEN 0
ELSE V_S2_Otgr.SumNak END) + (CASE
WHEN ISNULL(V_S2_Opl.KodPolOpl, 0) = 0 THEN 0 ELSE V_S2_Opl.SumOpl2
END) 0 AND odOplata.Flag >= 0 AND
odOplata.KodVal = 840) V_S1_Opl1_1 INNER JOIN
sprVal ON V_S1_Opl1_1.KodVal = sprVal.KodVal
WHERE V_S1_Opl1_1.DateOpl 0 AND ProductRef.KodVal =
840) V_S2_Otgr1_1 INNER JOIN
sprVal ON V_S2_Otgr1_1.KodVal = sprVal.KodVal
WHERE V_S2_Otgr1_1.DateOtgr >= @DateBeg AND
V_S2_Otgr1_1.DateOtgr = 0 AND odOplata.KodVal =
840) V_S2_Opl2_2 INNER JOIN
sprVal ON V_S2_Opl2_2.KodVal = sprVal.KodVal
WHERE V_S2_Opl2_2.DateOpl >= @DateBeg AND V_S2_Opl2_2.DateOpl 0 AND ProductRef.KodVal =
840) V_S3_Otgr3_1 INNER JOIN
sprVal ON V_S3_Otgr3_1.KodVal = sprVal.KodVal
WHERE V_S3_Otgr3_1.DateOtgr 0) V_S_1_2_3
WHERE V_S_1_2_3.Saldo0 0 OR
V_S_1_2_3.OborOtgr 0 OR
V_S_1_2_3.OborOpl 0 OR
V_S_1_2_3.Saldo1 0
