Index: trunk/SQL/Views/VIEW_RAPORT_ZMIAN_EMISJI.txt
===================================================================
--- trunk/SQL/Views/VIEW_RAPORT_ZMIAN_EMISJI.txt (revision 278)
+++ trunk/SQL/Views/VIEW_RAPORT_ZMIAN_EMISJI.txt (revision 363)
@@ -6,6 +6,15 @@
 
 ALTER view [dbo].[VIEW_RAPORT_ZMIAN_EMISJI] as
-SELECT T.idFaktury,
-CAST(F.numer AS NVARCHAR(3)) + '/' + CAST(F.numer_roz AS NVARCHAR(3))  + '/' + CAST(F.numer_rok AS NVARCHAR(4)) AS NrFaktury,
+SELECT 
+idFaktury = 
+CASE
+ WHEN FPK.IDPozKat IS NULL THEN T.idFaktury
+ ELSE FPK.ID
+END,
+NrFaktury = 
+CASE
+ WHEN FPK.IDPozKat IS NULL THEN CAST(F.numer AS NVARCHAR(3)) + '/' + CAST(F.numer_roz AS NVARCHAR(3))  + '/' + CAST(F.numer_rok AS NVARCHAR(4)) --AS NrFaktury
+ ELSE FPK.NrFaktury
+END,
 T. reklamaId, 
 R.[id reklamy],
@@ -15,5 +24,8 @@
 T.netto, 
 NR.DATA_W, 
-T.Korekta FROM 
+T.Korekta,
+NR.Tyt AS Tytul,
+L.id AS TytulId
+FROM 
 (
 SELECT U.idFaktury, U.reklamaId, ZE.idEmisji, ZE.popNrWyd AS nrWyd, ZE.dataZmiany, - U.netto AS netto, 0 AS Korekta 
@@ -36,4 +48,7 @@
 LEFT JOIN klienci K ON Z.idKlienta = K.customerId
 LEFT JOIN NR ON NR.TYT=R.tytu³ AND NR.NRW=T.nrWyd
+LEFT JOIN [Lista Tytu³ów] L ON NR.TYT=L.Symb
+--WHERE F.ID_SPRZEDAWCY NOT IN (4,6)
+LEFT JOIN FakturyPoznanKatowice FPK ON F.ID_Faktury=FPK.IDPozKat
 GO