|
Wersja 275, 1.1 KB
(wprowadzona przez marek, 17 years temu)
|
|
re #5 - poprawiono wystawianie faktury dla Poznania i Katowic, teraz uwzglednia wyroznienia
|
| Line | |
|---|
| 1 |
|
|---|
| 2 | SET ANSI_NULLS ON
|
|---|
| 3 | GO
|
|---|
| 4 | SET QUOTED_IDENTIFIER ON
|
|---|
| 5 | GO
|
|---|
| 6 |
|
|---|
| 7 | ALTER VIEW [dbo].[FakturyPoznanKatowice] AS
|
|---|
| 8 | SELECT FakturyPozKat.* FROM
|
|---|
| 9 | (
|
|---|
| 10 | SELECT DISTINCT F.id_faktury AS ID,
|
|---|
| 11 | CONVERT(VARCHAR,F.NUMER) + '/' + CONVERT(VARCHAR,F.NUMER_ROZ) + '/' + CONVERT(VARCHAR,F.NUMER_ROK) AS NrFaktury,
|
|---|
| 12 | F.[DATA_SPRZEDAZY] AS DataSprzedazy,
|
|---|
| 13 | F2.ID_FAKTURY AS IDPozKat,
|
|---|
| 14 | CONVERT(VARCHAR,F2.NUMER) + '/' + CONVERT(VARCHAR,F2.NUMER_ROZ) + '/' + CONVERT(VARCHAR,F2.NUMER_ROK) AS NrFakturyPozKat,
|
|---|
| 15 | DATEPART(week, F2.DATA_WYSTAWIENIA) AS NrTygodnia,
|
|---|
| 16 | SUM(FD.NETTO) AS Netto,
|
|---|
| 17 | SUM(FD2.NETTO) AS NettoPozKat
|
|---|
| 18 | FROM FAKTURA_DETAILS FD
|
|---|
| 19 | LEFT JOIN faktury F ON F.id_faktury = FD.id_faktury
|
|---|
| 20 | LEFT JOIN FAKTURA_DETAILS FD2 ON FD.reklamaId = FD2.reklamaId AND FD.NR_WYDANIA = FD2.NR_WYDANIA
|
|---|
| 21 | LEFT JOIN FAKTURY F2 ON FD2.id_Faktury = F2.id_faktury
|
|---|
| 22 | WHERE F.NUMER_ROZ = 'POZ' OR F.NUMER_ROZ='KAT'
|
|---|
| 23 | GROUP BY F.id_faktury, F.NUMER, F.NUMER_ROZ, F.NUMER_ROK, F.[DATA_SPRZEDAZY], F2.ID_FAKTURY, F2.NUMER, F2.NUMER_ROZ, F2.NUMER_ROK, F2.DATA_WYSTAWIENIA
|
|---|
| 24 | ) FakturyPozKat
|
|---|
| 25 | WHERE ID <> IDPozKat
|
|---|
| 26 | GO
|
|---|
| 27 |
|
|---|
| 28 | SET ANSI_NULLS OFF
|
|---|
| 29 | GO
|
|---|
| 30 | SET QUOTED_IDENTIFIER OFF
|
|---|
| 31 | GO
|
|---|
| 32 |
|
|---|
Notatka: Zobacz
TracBrowser
aby uzyskać więcej informacji.
