Index: trunk/SQL/StoredProcedures/sp_GetReklamy.txt
===================================================================
--- trunk/SQL/StoredProcedures/sp_GetReklamy.txt (revision 312)
+++ trunk/SQL/StoredProcedures/sp_GetReklamy.txt (revision 313)
@@ -6,7 +6,7 @@
 
 -- =============================================
--- Author:		<Author,,Name>
--- Create date: <Create Date,,>
--- Description:	<Description,,>
+-- Author:		marek
+-- Create date: 2009-02-08
+-- Description:	Wyszukuje reklamy odpowiedniodo podanych parametrow
 -- =============================================
 ALTER PROCEDURE [dbo].[sp_GetReklamy] 
@@ -69,5 +69,4 @@
 
 if NOT (@ms IS NULL)
---SET @query = @query + ' AND DATEPART(month,NR.DATA_W)=' + CAST(@ms as nvarchar) + ' '
 BEGIN
 SET @query = @query + ' AND DATEPART(month, O.data_od)<=' + CAST(@ms as nvarchar) + ' '
@@ -93,10 +92,24 @@
 END
 
+IF NOT (@zd IS NULL)
+SET @query = @query + ' AND R.[Zatwierdzono do druku]=' + CAST(@zd as nvarchar) + ' '
 
-print @query
+IF NOT (@kz IS NULL)
+SET @query = @query + ' AND R.[Kier_zatwierdzil]=' + CAST(@kz as nvarchar) + ' '
+
+IF NOT (@wy IS NULL)
+SET @query = @query + ' AND R.[wyroznienie]=' + CAST(@wy as nvarchar) + ' '
+
+IF NOT (@bz IS NULL)
+BEGIN
+IF @bz=1
+SET @query = @query + ' AND R.idZamowienia IS NULL '
+ELSE
+SET @query = @query + ' AND R.idZamowienia IS NOT NULL '
+END
 
 
---SET @query = 'DECLARE @result TABLE ( id INT PRIMARY KEY ) INSERT INTO @result ' + @query
---SET @query = @query + ' SELECT * FROM @result'
+--print @query
+
 
 EXECUTE sp_executesql @query