Index: trunk/SQL/StoredProcedures/sp_GetReklamy.txt
===================================================================
--- trunk/SQL/StoredProcedures/sp_GetReklamy.txt (revision 313)
+++ trunk/SQL/StoredProcedures/sp_GetReklamy.txt (revision 339)
@@ -6,7 +6,7 @@
 
 -- =============================================
--- Author:		marek
--- Create date: 2009-02-08
--- Description:	Wyszukuje reklamy odpowiedniodo podanych parametrow
+-- Author:		<Author,,Name>
+-- Create date: <Create Date,,>
+-- Description:	<Description,,>
 -- =============================================
 ALTER PROCEDURE [dbo].[sp_GetReklamy] 
@@ -18,4 +18,5 @@
 @tytul nvarchar(100) = NULL,
 @typ nvarchar(100) = NULL,
+@promocja int = NULL,
 @zd bit = NULL,
 @fw bit = NULL,
@@ -80,4 +81,7 @@
 SET @query = @query + ' AND R.[TYP]=''' + @typ + ''' '
 
+if NOT (@promocja IS NULL)
+SET @query = @query + ' AND R.[Promocja]=' + CAST(@promocja as nvarchar) + ' '
+
 if (NOT (@fw IS NULL) AND NOT(@ms IS NULL) AND NOT(@rok IS NULL))
 BEGIN