| Line | |
|---|
| 1 | SELECT
|
|---|
| 2 | agencja,
|
|---|
| 3 | agent,
|
|---|
| 4 | kodKlienta,
|
|---|
| 5 | DATA_SPRZEDAZY,
|
|---|
| 6 | TERMIN_ZAPLATY,
|
|---|
| 7 | numer,
|
|---|
| 8 | numer_roz,
|
|---|
| 9 | SUM(brutto) AS brutto,
|
|---|
| 10 | SUM(wplata_brutto) AS suma_zaplat,
|
|---|
| 11 | Sum(zalega) AS zalega,
|
|---|
| 12 | SUM(waluta_brutto) AS brutto_waluta,
|
|---|
| 13 | SUM(wplata_brutto_waluta) AS suma_zaplat_waluta,
|
|---|
| 14 | Sum(zalega_waluta) AS zalega_waluta,
|
|---|
| 15 | count(id_faktury) AS ILOSC,
|
|---|
| 16 | CONVERT(float, (SUM(zalega))) / CONVERT(float, SUM(brutto)) AS procent
|
|---|
| 17 | FROM
|
|---|
| 18 | (
|
|---|
| 19 | SELECT
|
|---|
| 20 | V1.id_faktury,
|
|---|
| 21 | V2.id_agencji,
|
|---|
| 22 | agent,
|
|---|
| 23 | kodKlienta,
|
|---|
| 24 | V2.DATA_SPRZEDAZY,
|
|---|
| 25 | V2.TERMIN_ZAPLATY,
|
|---|
| 26 | V2.numer,
|
|---|
| 27 | V2.numer_roz,
|
|---|
| 28 | V1.brutto,
|
|---|
| 29 | V1.waluta_brutto,
|
|---|
| 30 | wplaty.brutto AS wplata_brutto,
|
|---|
| 31 | wplaty.waluta_brutto AS wplata_brutto_waluta,
|
|---|
| 32 | V1.brutto - wplaty.brutto AS zalega,
|
|---|
| 33 | V1.waluta_brutto - wplaty.waluta_brutto as zalega_waluta,
|
|---|
| 34 | dbo.AGENCJE.Symbol AS Agencja
|
|---|
| 35 | FROM VIEW_BRUTTO_PO_KOREKTACH V1
|
|---|
| 36 | LEFT JOIN View_ZESTAWIENIE_LISTA_FAKTUR_nowa V2 ON V1.id_faktury = V2.id_faktury
|
|---|
| 37 | INNER JOIN Wplaty ON V1.id_faktury = Wplaty.idFaktury
|
|---|
| 38 | INNER JOIN dbo.AGENCJE ON V2.ID_AGENCJI = dbo.AGENCJE.ID_AGENCJI
|
|---|
| 39 | WHERE year(V2.DATA_SPRZEDAZY) = 2009 AND (V1.brutto - V2.suma_zaplat) > 0 AND V2.SystemKsiegowyId IN (@systemKsiegowy)
|
|---|
| 40 | ) T
|
|---|
| 41 | GROUP BY agencja, agent,kodKlienta,DATA_SPRZEDAZY, TERMIN_ZAPLATY, numer, numer_roz
|
|---|
| 42 | ORDER BY zalega DESC |
|---|
Notatka: Zobacz
TracBrowser
aby uzyskać więcej informacji.
