Index: trunk/SQL/StoredProcedures/sp_AddUpdateIssueChange.txt
===================================================================
--- trunk/SQL/StoredProcedures/sp_AddUpdateIssueChange.txt (revision 764)
+++ trunk/SQL/StoredProcedures/sp_AddUpdateIssueChange.txt (revision 824)
@@ -20,4 +20,48 @@
 	-- interfering with SELECT statements.
 	SET NOCOUNT ON;
+
+DECLARE @invoiceId INT
+DECLARE @sellDate DATETIME
+DECLARE @currentIssueDate DATETIME
+DECLARE @newIssueDate DATETIME
+DECLARE @adName VARCHAR(20)
+
+SELECT @invoiceId=F.Id_Faktury, 
+@sellDate=F.Data_Sprzedazy, 
+@currentIssueDate = N.Data_W, 
+@newIssueDate=N1.data_w,
+@adName=R.[Id Reklamy]
+FROM dbo.[Uka¿e siê w Nr] U
+INNER JOIN Reklama R ON U.ReklamaId=R.ReklamaId
+INNER JOIN Nr N ON N.Tyt=R.[tytu³] AND N.Nrw=U.[Nr Wydania]
+INNER JOIN Faktury F ON F.id_Faktury=U.idFaktury
+INNER JOIN Nr N1 ON N1.Tyt=R.[tytu³] AND N1.Nrw=@newIssueNumber
+WHERE U.id=@issueId
+
+IF @invoiceId IS NULL GOTO END_PROC
+
+IF (MONTH(@sellDate)=MONTH(GETDATE()) AND YEAR(@sellDate)=YEAR(GETDATE()))
+	AND
+	(
+	(MONTH(@currentIssueDate)=MONTH(GETDATE()) AND YEAR(@currentIssueDate)=YEAR(GETDATE()))
+	OR
+	(MONTH(@newIssueDate)=MONTH(GETDATE()) AND YEAR(@newIssueDate)=YEAR(GETDATE()))
+	)
+BEGIN
+
+UPDATE dbo.Faktury
+SET ZmianaEmisji=1
+WHERE id_faktury=@invoiceId
+
+UPDATE dbo.Faktura_Details
+SET Rok=YEAR(@newIssueDate), Miesiac=MONTH(@newIssueDate), 
+Nazwa_Uslugi=@adName + ' | ' + CAST(@newIssueNumber AS VARCHAR),
+Nr_Wydania=@newIssueNumber
+WHERE id_faktury=@invoiceId AND Nr_Wydania=@currentIssueNumer
+
+
+GOTO END_PROC
+END
+
 
     -- Insert statements for procedure here
@@ -44,4 +88,6 @@
 		END
 
+END_PROC:
+
 END
 GO