Zbiór zmian 474

Data:

2009-03-19 16:26:26 (17 years ago)

Autor:

marek

Opis:

fixes #131

Lokalizacja:

trunk

Pliki:

• BazaReklam/app.config (zmodyfikowane) (1 diff)
• SQL/Views/VIEW_ZESTAWIENIE_FAKTUR_STARE.txt (zmodyfikowane) (1 diff)

trunk/BazaReklam/app.config

@@ -12 +12 @@
     <add name="BAZA_REKLAM" connectionString="Data Source=sql.ct.com.pl;Initial Catalog=BAZA_REKLAM;Persist Security Info=True"
       providerName="System.Data.SqlClient" />
-    <!--<add name="BAZA_REKLAM_TEST" connectionString="Data Source=sql.ct.com.pl;Initial Catalog=BAZA_REKLAM_TEST;Persist Security Info=True"
-      providerName="System.Data.SqlClient" />-->
+    <add name="BAZA_REKLAM_TEST" connectionString="Data Source=sql.ct.com.pl;Initial Catalog=BAZA_REKLAM_TEST;Persist Security Info=True"
+      providerName="System.Data.SqlClient" />
   </connectionStrings>
   <applicationSettings>

trunk/SQL/Views/VIEW_ZESTAWIENIE_FAKTUR_STARE.txt

@@ -21 +21 @@
 FAKTURY.waluta_brutto, 
 FAKTURY.waluta_miano, 
-FAKTURY.suma_zaplat, 
+COALESCE(FAKTURY.suma_zaplat, 0) AS suma_zaplat,
 FAKTURY.ID_FAKTURY, 
 AGENCI.Symbol,