| 1 | | SELECT AgencjaId, Agencja, Tytul, |
| 2 | | SUM(FakturaNetto) AS FakturaNetto, |
| 3 | | SUM(FakturaBrutto) AS FakturaBrutto, |
| 4 | | SUM(WplataBrutto) AS WplataBrutto |
| 5 | | FROM FakturyZaplacone |
| 6 | | WHERE |
| 7 | | Rok = @rok |
| 8 | | AND Miesiac IN (@ms) |
| 9 | | AND (AgencjaId IN (@agencja)) |
| 10 | | AND (Tytul IN (@tytul)) |
| 11 | | GROUP BY AgencjaId, Agencja, Tytul |
| 12 | | ORDER BY Agencja, Tytul |
| | 1 | SELECT |
| | 2 | Agencja, Tytul, |
| | 3 | Sum(Netto) AS FakturaNetto, |
| | 4 | Sum(Brutto) AS FakturaBrutto, |
| | 5 | Sum(suma_zaplat) AS WplataBrutto |
| | 6 | |
| | 7 | FROM WplywyByTytul |
| | 8 | WHERE (YEAR(dataWplaty) = @rok) AND (MONTH(dataWplaty) IN (@ms)) AND (Tytul IN (@tytul)) AND (SystemKsiegowyId IN (@systemKsiegowy)) |
| | 9 | GROUP BY Agencja, Tytul |
