| Line | |
|---|
| 1 |
|
|---|
| 2 | SELECT
|
|---|
| 3 | W.Agencja,
|
|---|
| 4 | LOWER(W.Symbol) AS Agent,
|
|---|
| 5 | A.[Imiê] AS Imie,
|
|---|
| 6 | A.Nazwisko,
|
|---|
| 7 | COUNT(W.ID_FAKTURY) AS IloscFaktur,
|
|---|
| 8 | SUM(W.Netto) AS Netto,
|
|---|
| 9 | ROUND(SUM(W.Netto * W.procentProwizji), 2) AS Prowizja,
|
|---|
| 10 | A.Pracownicy
|
|---|
| 11 | FROM WplywyByTytul W
|
|---|
| 12 | LEFT OUTER JOIN AGENCI A ON A.Symbol=W.Symbol
|
|---|
| 13 | WHERE (YEAR(W.dataWplaty) = @rok) AND (MONTH(W.dataWplaty) = @miesiac)
|
|---|
| 14 | AND (@pracownicy IS NULL OR A.Pracownicy = @pracownicy)
|
|---|
| 15 | AND (@prawa_agent IS NULL OR W.Symbol=@prawa_agent)
|
|---|
| 16 |
|
|---|
| 17 | GROUP BY W.Agencja, W.Symbol, A.[Imiê], A.Nazwisko, A.Pracownicy
|
|---|
| 18 | ORDER BY A.Nazwisko
|
|---|
Notatka: Zobacz
TracBrowser
aby uzyskać więcej informacji.
