| 154 | | <CommandText>SELECT R.TYTUÅ, U.[Nr Wydania] AS NR, R.[SYMBOL AKWIZYTORA], A.Id_agencji, N.DATA_W, SUM(U.netto) AS netto, COUNT(U.ID) AS ilosc |
| 155 | | FROM AGENCI AS A2 LEFT OUTER JOIN |
| 156 | | AGENCJE AS A ON A.Id_agencji = A2.ID_AGENCJI INNER JOIN |
| 157 | | REKLAMA AS R ON A2.Symbol = R.[SYMBOL AKWIZYTORA] INNER JOIN |
| 158 | | [UKAÅ»E SIÄ W NR] AS U ON R.ReklamaID = U.ReklamaId LEFT OUTER JOIN |
| 159 | | NR AS N ON N.TYT = R.TYTUÅ AND N.NRW = U.[Nr Wydania] |
| 160 | | WHERE (R.[ZATWIERDZONO DO DRUKU] = 1) AND (YEAR(N.DATA_W) = @rok) AND (R.TYTUÅ = @tytul) AND (U.[Nr Wydania] >= @od) AND |
| 161 | | (U.[Nr Wydania] <= @do) |
| | 154 | <CommandText>SELECT |
| | 155 | R.TYTUÅ, |
| | 156 | U.[Nr Wydania] AS NR, |
| | 157 | R.[SYMBOL AKWIZYTORA], |
| | 158 | A.Id_agencji, |
| | 159 | N.DATA_W, |
| | 160 | netto = |
| | 161 | CASE |
| | 162 | WHEN COALESCE(SUM(U.netto), 0)=0 THEN CAST(SUM(R.[Cena Jedn]-R.[Rabat WartoÅÄ]) AS DECIMAL(9,2)) |
| | 163 | ELSE CAST(COALESCE(SUM(U.netto), 0) AS DECIMAL(9,2)) |
| | 164 | END, |
| | 165 | COUNT(U.ID) AS ilosc |
| | 166 | FROM AGENCI AS A2 |
| | 167 | LEFT OUTER JOIN AGENCJE AS A ON A.Id_agencji = A2.ID_AGENCJI |
| | 168 | INNER JOIN REKLAMA AS R ON A2.Symbol = R.[SYMBOL AKWIZYTORA] |
| | 169 | INNER JOIN [UKAÅ»E SIÄ W NR] AS U ON R.ReklamaID = U.ReklamaId |
| | 170 | LEFT OUTER JOIN NR AS N ON N.TYT = R.TYTUÅ AND N.NRW = U.[Nr Wydania] |
| | 171 | WHERE (R.[ZATWIERDZONO DO DRUKU] = 1) |
| | 172 | AND (YEAR(N.DATA_W) = @rok) |
| | 173 | AND (R.TYTUÅ = @tytul) |
| | 174 | AND (U.[Nr Wydania] >= @od) |
| | 175 | AND (U.[Nr Wydania] <= @do) |
