ogarnąłem to ciut inaczej, ale również skutecznie:
Kod: Zaznacz cały
select KodGTU from (
select TrN_GIDTyp DokGidtyp, GidNumer DokGidNumer, KodGTU,TraSVat.* from (
SELECT DISTINCT trj_trnnumer AS 'GidNumer',
( SELECT SUBSTRING(
(SELECT ',' + TrJ_Wartosc
FROM cdn.TraJPK (nolock)
WHERE trj_wartosc like 'GTU%' and trj_trnnumer = t.trj_trnnumer FOR XML PATH('')), 2, 200000)
) AS 'KodGTU'
FROM cdn.trajpk t
) AS Z
JOIN cdn.TraNag (nolock) ON (TrN_GIDNumer=GidNumer)
join CDN.TraSVat ON TSV_GIDNumer = TrN_GIDNumer AND TSV_GIDTyp = TrN_GIDTyp
) AS ZZ
where {filtrsql}
Kod: Zaznacz cały
TrN_GidNumer in (SELECT Trn_GIDNumer FROM CDN.TraNag
inner join cdn.trajpk on TrN_GIDTyp=TrJ_TrNTyp AND TrN_GIDNumer=TrJ_TrNNumer
WHERE trj_wartosc not like 'GTU%')