Forum ERP XL

Kod: Zaznacz cały

select 
    CASE 
        WHEN K1.Knt_GidNumer IS NOT NULL AND K2.Knt_GidNumer IS NOT NULL 
             AND K1.Knt_GidNumer <> K2.Knt_GidNumer 
        THEN K1.Knt_Akronim + ' / ' + K2.Knt_Akronim
        ELSE COALESCE(K1.Knt_Akronim, K2.Knt_Akronim, '')
    END as [Kontrahent]

from cdn.RozniceKursowe
-- Tranag
left join CDN.TraNag T1 on T1.Trn_GidTyp = RKN_Dok1Typ and T1.Trn_GidNumer = RKN_Dok1Numer
left join CDN.TraNag T2 on T2.Trn_GidTyp = RKN_Dok2Typ and T2.Trn_GidNumer = RKN_Dok2Numer
--ImpNag
left join CDN.ImpNag I1 on I1.ImN_GidTyp = RKN_Dok1Typ and I1.ImN_GidNumer = RKN_Dok1Numer
left join CDN.ImpNag I2 on I2.ImN_GidTyp = RKN_Dok2Typ and I2.ImN_GidNumer = RKN_Dok2Numer
--Zapisy
left join CDN.Zapisy Z1 on Z1.KAZ_GIDTyp = RKN_Dok1Typ and Z1.KAZ_GIDNumer = RKN_Dok1Numer
left join CDN.Zapisy Z2 on Z2.KAZ_GIDTyp = RKN_Dok2Typ and Z2.KAZ_GIDNumer = RKN_Dok2Numer
--Kontrahenci
left join CDN.KntKarty K1 on K1.Knt_GidNumer = COALESCE(T1.Trn_KntNumer, I1.ImN_KntNumer, Z1.KAZ_KNTNumer)
left join CDN.KntKarty K2 on K2.Knt_GidNumer = COALESCE(T2.Trn_KntNumer, I2.ImN_KntNumer, Z2.KAZ_KNTNumer)

where {filtrsql}