Index: branches/TruckExpo/SQL/Functions/podajEmisje.txt
===================================================================
--- branches/TruckExpo/SQL/Functions/podajEmisje.txt (revision 436)
+++ branches/TruckExpo/SQL/Functions/podajEmisje.txt (revision 436)
@@ -0,0 +1,30 @@
+
+SET ANSI_NULLS ON
+GO
+SET QUOTED_IDENTIFIER ON
+GO
+
+ALTER function [dbo].[podajEmisje]
+(
+@reklamaId int
+)
+returns nvarchar(1024)
+as
+begin
+declare @emisje nvarchar(1024)
+
+select 
+	@emisje = coalesce(@emisje + ', ','') + cast([Nr wydania] as nvarchar(4))
+	from dbo.[UKA¯E SIÊ W NR] 
+	where reklamaId = @reklamaId
+	order by [Nr wydania]
+
+return @emisje
+end
+GO
+
+SET ANSI_NULLS OFF
+GO
+SET QUOTED_IDENTIFIER OFF
+GO
+
Index: branches/TruckExpo/SQL/Views/ZAMOWIENIA_NETTO_ZAFAKTUROWANE.txt
===================================================================
--- branches/TruckExpo/SQL/Views/ZAMOWIENIA_NETTO_ZAFAKTUROWANE.txt (revision 436)
+++ branches/TruckExpo/SQL/Views/ZAMOWIENIA_NETTO_ZAFAKTUROWANE.txt (revision 436)
@@ -0,0 +1,22 @@
+
+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 AND zafakturowana=1
+GROUP BY Z.idZamowienia
+GO
+
+SET ANSI_NULLS OFF
+GO
+SET QUOTED_IDENTIFIER OFF
+GO
+