Zbiór zmian 162 dla trunk/RaportySQL/SprzedazReklam2009.rdl

Data:

2009-01-12 23:18:43 (17 years ago)

Autor:

dorota

Opis:

lista lat >= 2009

Pliki:

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

trunk/RaportySQL/SprzedazReklam2009.rdl

@@ -191 +191 @@
       <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) &gt;=2009 order by year(DATA_W)desc</CommandText>
         <rd:UseGenericDesigner>true</rd:UseGenericDesigner>
       </Query>