Index: trunk/SQL/Triggers/REKLAMA_UPDATE.txt
===================================================================
--- trunk/SQL/Triggers/REKLAMA_UPDATE.txt (revision 396)
+++ trunk/SQL/Triggers/REKLAMA_UPDATE.txt (revision 396)
@@ -0,0 +1,101 @@
+
+SET ANSI_NULLS ON
+GO
+SET QUOTED_IDENTIFIER ON
+GO
+
+ALTER TRIGGER [REKLAMA_UPDATE] ON [dbo].[REKLAMA] 
+FOR UPDATE
+AS
+DECLARE @id INT
+DECLARE @id1 VARCHAR(100)
+DECLARE @opis VARCHAR(4000)
+
+SELECT @id1=[ID REKLAMY], @id=ReklamaID  FROM DELETED
+
+SET @opis=''
+
+IF UPDATE([ID REKLAMY])
+BEGIN
+    SET @opis=@opis+' ID_REKLAMY: '+@id1+' na '+(SELECT [ID REKLAMY] FROM INSERTED)
+END
+ 
+IF UPDATE(SZER)
+BEGIN
+    SET @opis=@opis+' SZER: '+(SELECT   CONVERT(varchar(100),SZER) FROM DELETED)+' na '+(SELECT CONVERT(varchar(100),SZER) FROM INSERTED)
+END
+
+IF UPDATE(waluta_kurs)
+BEGIN
+    SET @opis=@opis+' waluta_kurs: '+(SELECT CONVERT(varchar(100), COALESCE(waluta_kurs,'')) FROM DELETED)+' na '+(SELECT CONVERT(varchar(100), COALESCE(waluta_kurs,'')) FROM INSERTED)
+END
+
+IF UPDATE(Brutto_Euro_Miano)
+BEGIN
+	SET @opis=@opis+' waluta_miano: '+(SELECT CONVERT(varchar(100),COALESCE(Brutto_Euro_Miano,'')) FROM DELETED)+' na '+(SELECT CONVERT(varchar(100),COALESCE(Brutto_Euro_Miano,'')) FROM INSERTED)
+END
+    
+IF UPDATE(WYS)
+BEGIN
+	SET @opis=@opis+' WYS: '+(SELECT CONVERT(varchar(100),WYS) FROM DELETED)+' na '+(SELECT CONVERT(varchar(100),WYS) FROM INSERTED)
+END
+    
+IF UPDATE(MOD_TYP)
+BEGIN
+	SET @opis=@opis+' MOD_TYP: '+(SELECT CONVERT(varchar(100),MOD_TYP) FROM DELETED)+' na '+(SELECT CONVERT(varchar(100),MOD_TYP) FROM INSERTED)
+END
+    
+IF UPDATE([KROTNOή])
+BEGIN
+    SET @opis=@opis+' KROTNOή: '+(SELECT CONVERT(varchar(100),KROTNOή) FROM DELETED)+' na '+(SELECT CONVERT(varchar(100),KROTNOή) FROM INSERTED)
+END
+
+IF UPDATE(RABAT)
+BEGIN
+    SET @opis=@opis+' RABAT: '+(SELECT CONVERT(varchar(100),RABAT) FROM DELETED)+' na '+(SELECT CONVERT(varchar(100),RABAT) FROM INSERTED)
+END
+
+IF UPDATE([ZATWIERDZONO DO DRUKU])
+BEGIN
+    SET @opis=@opis+' ZATWIERDZONO DO DRUKU: '+(SELECT CONVERT(varchar(100),[ZATWIERDZONO DO DRUKU]) FROM DELETED)+' na '+(SELECT CONVERT(varchar(100),[ZATWIERDZONO DO DRUKU]) FROM INSERTED)
+END
+
+IF UPDATE(NETTO)
+BEGIN
+    SET @opis=@opis+' NETTO: '+(SELECT CONVERT(varchar(100),NETTO) FROM DELETED)+' na '+(SELECT CONVERT(varchar(100),NETTO) FROM INSERTED)
+END
+
+IF UPDATE([FAKTURA WYSTAWIONO])
+BEGIN
+    SET @opis=@opis+' FAKTURA WYSTAWIONO: '+(SELECT CONVERT(varchar(100),[FAKTURA WYSTAWIONO]) FROM DELETED)+' na '+(SELECT CONVERT(varchar(100),[FAKTURA WYSTAWIONO]) FROM INSERTED)
+END
+
+IF UPDATE([FAKTURA DATA WYSTAWIENIA])
+BEGIN
+	SET @opis=@opis+' FAKTURA data wystawienia: '+(SELECT CONVERT(varchar(100),COALESCE([FAKTURA DATA WYSTAWIENIA],'')) FROM DELETED)+' na '+(SELECT CONVERT(varchar(100),COALESCE([FAKTURA DATA WYSTAWIENIA],'')) FROM INSERTED)
+END
+
+IF UPDATE([FAKTURA TERMIN ZAP£ATY])
+BEGIN
+	SET @opis=@opis+' FAKTURA TERMIN ZAP£ATY: '+(SELECT CONVERT(varchar(100),COALESCE([FAKTURA TERMIN ZAP£ATY],'')) FROM DELETED)+' na '+(SELECT CONVERT(varchar(100),COALESCE([FAKTURA TERMIN ZAP£ATY],'')) FROM INSERTED)
+END
+    
+IF UPDATE(CustomerID)
+BEGIN
+	SET @opis=@opis+' Klient Agencji: '+(SELECT CONVERT(varchar(100),CustomerID) FROM DELETED)+' na '+(SELECT CONVERT(varchar(100),CustomerID) FROM INSERTED)
+END
+
+-- zapis do logu
+INSERT INTO LOG(OPERACJA,TABELA,OPIS,SZCZEGOLY)
+VALUES('UPDATE','REKLAMA',@id1,@opis)
+ 
+UPDATE REKLAMA
+SET [DATA OSTATNIEJ MODYFIKACJI]=CURRENT_TIMESTAMP
+WHERE ReklamaID=@id
+GO
+
+SET ANSI_NULLS OFF
+GO
+SET QUOTED_IDENTIFIER OFF
+GO
+