Kod: Zaznacz cały
@PAR ?@N6.2|kurs|&Kurs 100 EUR =:REG=0 @? @D( {??check=1}) @RH(500) @S(0.01) PAR@
@PAR ?@Hs50|ZazGUID|ZazGUID:'' PAR@
@PAR ?@X|check|Kurs z tabeli kursów walut:REG=0 @? PAR@
@PAR ?@R(SELECT ID = 1, 'SPRZEDAŻ' UNION
SELECT ID=2, 'BAZOWA' UNION
SELECT ID=3, 'MINIMALNA')|cena|&Wybierz cenę:REG=SPRZEDAŻ @? PAR@
select twr_kod as Kod, twr_nazwa as Nazwa, twc_wartosc as Cena, twc_waluta as Waluta, case when twc_waluta = 'EUR' then
twc_wartosc*case when ??_NQcheck=0 then ??_NQkurs else (select top 1 wae_kursl
from cdn.walelem
where wae_symbol = 'EUR'
and wae_lp = 1
order by wae_kursts desc) end /100 else twc_wartosc end as PLN,
case when twc_waluta = 'PLN'
then ROUND(twc_wartosc / (case when ??_NQcheck=0 then ??_NQkurs else (select top 1 wae_kursl
from cdn.walelem
where wae_symbol = 'EUR'
and wae_lp = 1
order by wae_kursts desc) end /100),2) else twc_wartosc end as EUR
from cdn.twrkarty
join cdn.twrceny on Twr_GIDNumer=TwC_TwrNumer
join cdn.wkrzaznaczenia2 on wkz2_gidtyp=twr_gidtyp and wkz2_gidnumer=twr_gidnumer
where WkZ2_GUID = ??_QZazGUID and twc_twrlp=??_NQcena and {FiltrSQL}