Index: trunk/SQL/StoredProcedures/sp_DeleteReklamaStrona.txt
===================================================================
--- trunk/SQL/StoredProcedures/sp_DeleteReklamaStrona.txt (revision 745)
+++ trunk/SQL/StoredProcedures/sp_DeleteReklamaStrona.txt (revision 745)
@@ -0,0 +1,34 @@
+
+SET ANSI_NULLS ON
+GO
+SET QUOTED_IDENTIFIER ON
+GO
+
+ALTER PROCEDURE [dbo].[sp_DeleteReklamaStrona]
+	@tytul varchar(10),
+	@nrWydania int
+AS
+DELETE FROM dbo.REKLAMA_STRONA 
+WHERE Nr_Wydania=@nrWydania
+AND ReklamaId IN 
+(
+	SELECT 
+	R.ReklamaID	
+	FROM dbo.REKLAMA AS R 
+	INNER JOIN dbo.[UKA¯E SIÊ W NR] AS U ON R.ReklamaID = U.ReklamaId 
+	INNEr JOIN dbo.Nr AS Nr ON Nr.Tyt=R.[TYTU£] AND Nr.NRW=U.[Nr Wydania]
+	LEFT OUTER JOIN dbo.GRZBIETY AS G ON R.GRZBIET = G.ID 
+	LEFT OUTER JOIN dbo.[LISTA TYTU£ÓW] AS T ON R.TYTU£ = T.SYMB
+	WHERE 
+	(R.[ZATWIERDZONO DO DRUKU] = 1) 
+	AND (U.[Nr Wydania] = @nrWydania) 
+	AND (U.status <> 2) 
+	AND (T.Symb = @tytul)
+)
+GO
+
+SET ANSI_NULLS OFF
+GO
+SET QUOTED_IDENTIFIER OFF
+GO
+
Index: trunk/SQL/StoredProcedures/sp_DeleteReklamaStronaByStaryGrzbiet.txt
===================================================================
--- trunk/SQL/StoredProcedures/sp_DeleteReklamaStronaByStaryGrzbiet.txt (revision 745)
+++ trunk/SQL/StoredProcedures/sp_DeleteReklamaStronaByStaryGrzbiet.txt (revision 745)
@@ -0,0 +1,42 @@
+
+SET ANSI_NULLS ON
+GO
+SET QUOTED_IDENTIFIER ON
+GO
+
+ALTER PROCEDURE [dbo].[sp_DeleteReklamaStronaByStaryGrzbiet]
+	@tytul varchar(10),
+	@nrWydania int,
+	@staryGrzbiet int
+AS
+DELETE FROM dbo.REKLAMA_STRONA 
+WHERE Nr_Wydania=@nrWydania
+AND ReklamaId IN 
+(
+	SELECT ReklamaID FROM 
+	(
+	SELECT 
+	R.ReklamaID, 
+	dbo.getSectionForDTP (T.Id,R.grzbiet,R.ogl_dzial) AS GrzbietProdukcja,
+	R.TYTU£		
+	FROM dbo.REKLAMA AS R 
+	INNER JOIN dbo.[UKA¯E SIÊ W NR] AS U ON R.ReklamaID = U.ReklamaId 
+	INNEr JOIN dbo.Nr AS Nr ON Nr.Tyt=R.[TYTU£] AND Nr.NRW=U.[Nr Wydania]
+	LEFT OUTER JOIN dbo.GRZBIETY AS G ON R.GRZBIET = G.ID 
+	LEFT OUTER JOIN dbo.[LISTA TYTU£ÓW] AS T ON R.TYTU£ = T.SYMB
+	WHERE 
+	(R.[ZATWIERDZONO DO DRUKU] = 1) 
+	AND (U.[Nr Wydania] = @nrWydania) 
+	AND (U.status <> 2) 
+	AND (T.Symb = @tytul)
+	) Reklamy 
+	INNER JOIN dbo.GrzbietyProdukcja GP ON GP.Name = Reklamy.GrzbietProdukcja
+	WHERE GP.Id = @staryGrzbiet
+)
+GO
+
+SET ANSI_NULLS OFF
+GO
+SET QUOTED_IDENTIFIER OFF
+GO
+