root/trunk/SQL/StoredProcedures/sp_DeleteReklamaStrona.txt @ 745

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