TRIGGER [CDN].[TraNag_SEDKOMP_Cechofikator]

/****** Object:  Trigger [CDN].[TraNag_SEDKOMP_Cechofikator]    Script Date: 09/14/2012 12:11:04 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

-- =============================================
-- Author:      Piotr Osłowski
-- Create date: 2012-09-14
-- Description: Modyfikuje cechę na TraNagu w zależności od tablicy CDN.SED_TraNag_Cechofikator
-- =============================================
CREATE TRIGGER [CDN].[TraNag_SEDKOMP_Cechofikator]
   ON  [CDN].[TraNag]
   AFTER UPDATE
AS
BEGIN
    -- SET NOCOUNT ON added to prevent extra result sets from
    -- interfering with SELECT statements.
    SET NOCOUNT ON;

    -- Insert statements for trigger here

    DECLARE @typ int
    DECLARE @numer int
    DECLARE @cecha varchar(20)

    SELECT @typ = TrN_GIDTyp, @numer = TrN_GIDNumer FROM INSERTED

    --sprawdzamy czy nie ma zapisów w tablicy CDN.SED_TraNag_Cechofikator

    if (SELECT COUNT(*) FROM cdn.SED_TraNag_cechofikator WHERE SEDTrN_typ = @typ AND SEDTrN_numer = @numer) > 0
            Begin

                SELECT TOP 1 @cecha = SEDTrN_wartosc FROM cdn.SED_TraNag_cechofikator
                WHERE SEDTrN_typ = @typ AND SEDTrN_numer = @numer
                ORDER BY SEDTrN_ID DESC

                SET @cecha = IsNull(@cecha,'')


                UPDATE CDN.TraNag SET TrN_CechaOpis = @cecha
                WHERE TrN_GIDTyp = @typ AND TrN_GIDNumer = @numer

                DELETE FROM CDN.SED_TraNag_cechofikator
                WHERE SEDTrN_typ = @typ AND SEDTrN_numer = @numer


            End



END

GO