| | 1 | |
| | 2 | SET ANSI_NULLS ON |
| | 3 | GO |
| | 4 | SET QUOTED_IDENTIFIER ON |
| | 5 | GO |
| | 6 | |
| | 7 | ALTER VIEW [dbo].[VIEW_ZESTAWIENIE_ZAMOWIEN_NOWE] |
| | 8 | AS |
| | 9 | SELECT A2.Symbol AS agencja, A1.Symbol AS agent, z.idZamowienia, z.idKlienta, z.nrZamowienia, z.rokZamowienia, z.kodAgenta, |
| | 10 | K.kodKlienta + '/' + CAST(z.nrZamowienia AS nvarchar) + '/' + z.kodAgenta + '/' + CAST(z.rokZamowienia AS nvarchar) AS nrZamowieniaExt, |
| | 11 | R.iloscReklam, |
| | 12 | R.wartoscNetto, |
| | 13 | R.kwotaWalutaBrutto, |
| | 14 | ZE.data1 AS data_od, ZFK.data1 AS data_od_bez_FK, ZNFK.nettoZafakturowane, |
| | 15 | R.wartoscNetto - ZNFK.nettoZafakturowane AS DoZafakturowania, K.kodKlienta, r.Brutto_Euro_Miano |
| | 16 | FROM dbo.zamowienia AS z LEFT OUTER JOIN |
| | 17 | dbo.AGENCI AS A1 ON z.kodAgenta = A1.F_ROZ LEFT OUTER JOIN |
| | 18 | dbo.AGENCJE AS A2 ON A1.ID_AGENCJI = A2.Id_agencji LEFT OUTER JOIN |
| | 19 | dbo.KLIENCI AS K ON K.CustomerID = z.idKlienta LEFT OUTER JOIN |
| | 20 | dbo.ZAMOWIENIA_REKLAMY AS r ON z.idZamowienia = r.idZamowienia LEFT OUTER JOIN |
| | 21 | dbo.ZAMOWIENIA_1EMISJA AS ZE ON ZE.idZamowienia = z.idZamowienia LEFT OUTER JOIN |
| | 22 | dbo.ZAMOWIENIA_1EMISJA_bezFK AS ZFK ON ZFK.idZamowienia = z.idZamowienia LEFT OUTER JOIN |
| | 23 | dbo.ZAMOWIENIA_NETTO_ZAFAKTUROWANE AS ZNFK ON ZNFK.idZamowienia = z.idZamowienia |
| | 24 | GO |
| | 25 | |
| | 26 | SET ANSI_NULLS OFF |
| | 27 | GO |
| | 28 | SET QUOTED_IDENTIFIER OFF |
| | 29 | GO |
| | 30 | |
