Index: /trunk/SQL/Views/ZAMOWIENIA_REKLAMY.sql
===================================================================
--- /trunk/SQL/Views/ZAMOWIENIA_REKLAMY.sql (revision 213)
+++ /trunk/SQL/Views/ZAMOWIENIA_REKLAMY.sql (revision 213)
@@ -0,0 +1,33 @@
+
+SET ANSI_NULLS ON
+GO
+SET QUOTED_IDENTIFIER ON
+GO
+
+ALTER view [dbo].[ZAMOWIENIA_REKLAMY] as
+SELECT     z.idZamowienia,
+           COUNT(r.ReklamaID) AS iloscReklam, 
+			ROUND(SUM((r.[CENA JEDN] - r.[RABAT WARTOŚĆ]) * r.krotność * (1 + wyroznienie_procent)), 2) 
+		   AS wartoscNetto, SUM(r.Brutto_Euro) 
+              AS kwotaWalutaBrutto, r.Brutto_Euro_Miano
+FROM         dbo.zamowienia AS z left JOIN
+                      dbo.REKLAMA AS r ON z.idZamowienia = r.idZamowienia
+                     where r.Brutto_Euro_Miano is null or r.Brutto_Euro_Miano =''
+GROUP BY z.idZamowienia,r.Brutto_Euro_Miano
+union 
+SELECT     z.idZamowienia,
+           COUNT(r.ReklamaID) AS iloscReklam, 
+		    round(SUM(r.Brutto_Euro*r.waluta_kurs/(r.waluta_Przelicznik*(1+r.VAT))),2) 
+				  AS wartoscNetto, SUM(r.Brutto_Euro) 
+              AS kwotaWalutaBrutto, r.Brutto_Euro_Miano
+FROM         dbo.zamowienia AS z left JOIN
+                      dbo.REKLAMA AS r ON z.idZamowienia = r.idZamowienia
+                     where not (r.Brutto_Euro_Miano is null or r.Brutto_Euro_Miano ='')
+GROUP BY z.idZamowienia,r.Brutto_Euro_Miano
+GO
+
+SET ANSI_NULLS OFF
+GO
+SET QUOTED_IDENTIFIER OFF
+GO
+