Index: branches/Emisje/SQL/StoredProcedures/sp_GetAktywnePromocje.txt
===================================================================
--- branches/Emisje/SQL/StoredProcedures/sp_GetAktywnePromocje.txt (revision 780)
+++ branches/Emisje/SQL/StoredProcedures/sp_GetAktywnePromocje.txt (revision 780)
@@ -0,0 +1,28 @@
+
+SET ANSI_NULLS ON
+GO
+SET QUOTED_IDENTIFIER ON
+GO
+
+-- =============================================
+-- Author:		marek
+-- Create date: 24/07/2009
+-- Description:	Zwraca wszystkie aktywne promocje
+-- =============================================
+ALTER PROCEDURE [dbo].[sp_GetAktywnePromocje]
+AS
+BEGIN
+	-- SET NOCOUNT ON added to prevent extra result sets from
+	-- interfering with SELECT statements.
+	SET NOCOUNT ON;
+
+    -- Insert statements for procedure here
+	SELECT Id, Nazwa FROM dbo.Promocje WHERE Okres_od<= GETDATE() AND Okres_do>=GETDATE() ORDER BY Nazwa
+END
+GO
+
+SET ANSI_NULLS OFF
+GO
+SET QUOTED_IDENTIFIER OFF
+GO
+