Zbiór zmian 313 dla trunk/SQL/StoredProcedures/sp_GetReklamy.txt
- Data:
- 2009-02-08 22:02:28 (17 years ago)
- Pliki:
-
- 1 zmodyfikowane
-
trunk/SQL/StoredProcedures/sp_GetReklamy.txt (zmodyfikowane) (3 diffs)
Legenda:
- Bez zmian
- Dodane
- Usunięte
-
trunk/SQL/StoredProcedures/sp_GetReklamy.txt
r312 r313 6 6 7 7 -- ============================================= 8 -- Author: <Author,,Name>9 -- Create date: <Create Date,,>10 -- Description: <Description,,>8 -- Author: marek 9 -- Create date: 2009-02-08 10 -- Description: Wyszukuje reklamy odpowiedniodo podanych parametrow 11 11 -- ============================================= 12 12 ALTER PROCEDURE [dbo].[sp_GetReklamy] … … 69 69 70 70 if NOT (@ms IS NULL) 71 --SET @query = @query + ' AND DATEPART(month,NR.DATA_W)=' + CAST(@ms as nvarchar) + ' '72 71 BEGIN 73 72 SET @query = @query + ' AND DATEPART(month, O.data_od)<=' + CAST(@ms as nvarchar) + ' ' … … 93 92 END 94 93 94 IF NOT (@zd IS NULL) 95 SET @query = @query + ' AND R.[Zatwierdzono do druku]=' + CAST(@zd as nvarchar) + ' ' 95 96 96 print @query 97 IF NOT (@kz IS NULL) 98 SET @query = @query + ' AND R.[Kier_zatwierdzil]=' + CAST(@kz as nvarchar) + ' ' 99 100 IF NOT (@wy IS NULL) 101 SET @query = @query + ' AND R.[wyroznienie]=' + CAST(@wy as nvarchar) + ' ' 102 103 IF NOT (@bz IS NULL) 104 BEGIN 105 IF @bz=1 106 SET @query = @query + ' AND R.idZamowienia IS NULL ' 107 ELSE 108 SET @query = @query + ' AND R.idZamowienia IS NOT NULL ' 109 END 97 110 98 111 99 -- SET @query = 'DECLARE @result TABLE ( id INT PRIMARY KEY ) INSERT INTO @result ' +@query100 --SET @query = @query + ' SELECT * FROM @result' 112 --print @query 113 101 114 102 115 EXECUTE sp_executesql @query
