Index: trunk/SQL/Views/ZAMOWIENIA_NETTO_ZAFAKTUROWANE.txt
===================================================================
--- trunk/SQL/Views/ZAMOWIENIA_NETTO_ZAFAKTUROWANE.txt (revision 420)
+++ trunk/SQL/Views/ZAMOWIENIA_NETTO_ZAFAKTUROWANE.txt (revision 420)
@@ -0,0 +1,20 @@
+
+SET ANSI_NULLS ON
+GO
+SET QUOTED_IDENTIFIER ON
+GO
+
+ALTER view [dbo].[ZAMOWIENIA_NETTO_ZAFAKTUROWANE]
+as
+select Z.idZamowienia,round(sum (U.netto),2) as nettoZafakturowane from dbo.zamowienia as Z left join
+Reklama R on Z.idZamowienia = R.idZamowienia left join
+[UKA¯E SIÊ W NR] U on U.reklamaId = R.reklamaId
+where u.status<>2 
+group by Z.idZamowienia
+GO
+
+SET ANSI_NULLS OFF
+GO
+SET QUOTED_IDENTIFIER OFF
+GO
+