Zbiór zmian 184 dla trunk/RaportySQL/SprzedazReklamWYR.rdl

Data:

2009-01-18 14:06:31 (17 years ago)

Autor:

dorota

Opis:

 

Pliki:

• trunk/RaportySQL/SprzedazReklamWYR.rdl (zmodyfikowane) (1 diff)

trunk/RaportySQL/SprzedazReklamWYR.rdl

@@ -118 +118 @@
       <Query>
         <DataSourceName>BAZA_REKLAM</DataSourceName>
-        <CommandText>select distinct year(DATA_W) as rok from dbo.NR where DATA_W is not null order by year(DATA_W)desc</CommandText>
+        <CommandText>select distinct year(DATA_W) as rok from dbo.NR where DATA_W is not null and year(data_w)&lt;2009 order by year(DATA_W)desc</CommandText>
         <rd:UseGenericDesigner>true</rd:UseGenericDesigner>
       </Query>