Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- @PAR ?@S20|Seria|&Wprowadź serię i odśwież:REG= @? @MSG(Sprzedaż po ilości) @TIP(Opis w dymku) PAR@
- select
- 1 as ID
- , TrE_TwrKod as 'Kod'
- , TrE_TwrNazwa as 'Nazwa'
- , Replace(Convert(Decimal(10,2),SUM(TrE_Ilosc)),'.',',') as 'Suma'
- from cdn.TraNag
- join cdn.TraElem on TrE_GIDNumer = TrN_GIDNumer
- join cdn.KntAdresy on KnA_GIDNumer = TrN_KnANumer
- where {FiltrSQL} and TrN_TrNSeria like '%' + ??Seria + '%'
- group by TrE_TwrKod, TrE_TwrNazwa
- order by SUM(TrE_Ilosc) desc
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement