Select com mais de um IF

Assuntos Gerais
#1

Eu precisava fazer um SQL que se o salário fosse null ou <= 0, fizesse esse cálculo ((contribuicao*100)/arraliquota.funcional)), e se a contribuição fosse null ou <= 0 jogasse o salário na coluna nx_salário… Como que eu faço isso?

SELECT 
						data,arraliquota.funcional,
					
						IFNULL(salario ,((contribuicao*100)/arraliquota.funcional)) AS nv_salario,
						ano,mes,contribuicao,salario
				
				FROM 
					cntcontribuicao,arraliquota 
				WHERE 
						idsegurado='404' 
						GROUP BY 
						data, nv_salario, ano,mes
						ORDER BY ano,mes ASC
#2

Carinha, dependendo do banco de dados você pode utilizar o CASE - WHEN.

Dá uma olhada se o banco que está utilizando oferece esse recurso.

No caso, se for oracle só olhar aqui, e caso mesmo assim não funcione pode ser por causa da versão do oracle que está utilizando, então dê uma olhada nesse fórum.

SQL Server e Postgress também possuem, outros eu não tenho certeza.

Se estiver utilizando JPQL, não tem jeito, tem que fazer um POG básico.

#3

Estou utilizando o MySQL não sei se funciona.

#4

cara ,

outra maneira de fazer isso é utilizar a clausula union. ahi vc faz o seguinte:

  SELECT   
                           data,arraliquota.funcional,  
                         
                           IFNULL(salario ,((contribuicao*100)/arraliquota.funcional)) AS nv_salario,  
                           ano,mes,contribuicao,salario  
                     
                   FROM   
                       cntcontribuicao,arraliquota   
                   WHERE   
                           idsegurado='404'   
                           GROUP BY   
                           data, nv_salario, ano,mes  
                           ORDER BY ano,mes ASC  
                union

SELECT   
                           data,arraliquota.funcional,  
                         
                           IFNULL(salario ,([b][color=red](calculo_diferente)[/color][/b]) AS nv_salario,  
                           ano,mes,contribuicao,salario  
                     
                   FROM   
                       cntcontribuicao,arraliquota   
                   WHERE   
                           idsegurado='404'   
                      [b]  [color=red]and (salario = 0 ) or (salario is null)[/color][/b]
                           GROUP BY   
                           data, nv_salario, ano,mes  
                           ORDER BY ano,mes ASC
#5

Bom… teria ver se esse select funciona… mas creio que resolveria

SELECT data ,arraliquota.funcional ,CASE WHEN ((salario IS NULL OR salario <= 0) AND contribuicao IS NOT NULL) THEN ((contribuicao*100)/arraliquota.funcional) WHEN ((contribuicao IS NULL OR contribuicao <= 0) AND salario IS NOT NULL) THEN salario END AS nv_salario ,ano, mes, contribuicao, salario FROM cntcontribuicao, arraliquota WHERE idsegurado='404' GROUP BY data, nv_salario, ano, mes ORDER BY ano, mes ASC

#6

Eu fiz assim:


SELECT 
						data,arraliquota.funcional,
						IF (contribuicao > 0 && contribuicao is not null,
							(if (data >= arraliquota.data_inicio && data <= arraliquota.data_fim,0,contribuicao*100/arraliquota.funcional)),salario)
						/*IFNULL(salario ,((contribuicao*100)/arraliquota.funcional))*/ AS nv_salario,
						ano,mes,contribuicao,salario
				
				FROM 
					cntcontribuicao,arraliquota 
				WHERE 
						nv_salario != '0' AND
						idsegurado='3' 
						GROUP BY 
						data, nv_salario, ano,mes
						ORDER BY ano,mes ASC

Não está aceitando o 'nv_salario != ‘0’, como faço para retirar a linha inteira se o nv_salario for igual a zero? Ou o correto é eu fazer um filtro no código do servidor?

#7

CASE statement no MySQL:

http://www.google.com.br/search?hl=pt-BR&q=mysql+case+statement+example&meta=

http://dev.mysql.com/doc/refman/5.0/en/control-flow-functions.html

o/

#8

O seu select retornou o seguinte código, mandei gerar em HTML para você poder visualizar


<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" 
  "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html>
  <head>
    <title>SQL query</title>
    <meta name="GENERATOR" content="HeidiSQL Version 4.0, Revision 2405">
    <style type="text/css">
      thead tr {background-color: ActiveCaption; color: CaptionText;}
      th, td {vertical-align: top; font-family: "Tahoma"; font-size: 8pt; padding: 3px; }
      table, td {border: 1px solid silver;}
      table {border-collapse: collapse;}
      thead .col0 {width: 76px;}
      thead .col1 {width: 56px;}
      .col1 {text-align: right;}
      thead .col2 {width: 62px;}
      .col2 {text-align: right;}
      thead .col3 {width: 45px;}
      .col3 {text-align: right;}
      thead .col4 {width: 33px;}
      .col4 {text-align: right;}
      thead .col5 {width: 71px;}
      .col5 {text-align: right;}
      thead .col6 {width: 60px;}
      .col6 {text-align: right;}
    </style>
  </head>

  <body>

    <table caption="SQL query (148 rows)">
      <thead>
        <tr>
          <th class="col0">data</th>
          <th class="col1">funcional</th>
          <th class="col2">nv_salario</th>
          <th class="col3">ano</th>
          <th class="col4">mes</th>
          <th class="col5">contribuicao</th>
          <th class="col6">salario</th>
        </tr>
      </thead>
      <tbody>
        <tr>
          <td class="col0">1994-07-01</td>
          <td class="col1">11,0</td>
          <td class="col2">81,46</td>
          <td class="col3">1994</td>
          <td class="col4">7</td>
          <td class="col5">(NULL)</td>
          <td class="col6">81,46</td>
        </tr>
        <tr>
          <td class="col0">1994-08-01</td>
          <td class="col1">11,0</td>
          <td class="col2">81,46</td>
          <td class="col3">1994</td>
          <td class="col4">8</td>
          <td class="col5">(NULL)</td>
          <td class="col6">81,46</td>
        </tr>
        <tr>
          <td class="col0">1994-09-01</td>
          <td class="col1">11,0</td>
          <td class="col2">88,02</td>
          <td class="col3">1994</td>
          <td class="col4">9</td>
          <td class="col5">(NULL)</td>
          <td class="col6">88,02</td>
        </tr>
        <tr>
          <td class="col0">1994-10-01</td>
          <td class="col1">11,0</td>
          <td class="col2">92,42</td>
          <td class="col3">1994</td>
          <td class="col4">10</td>
          <td class="col5">(NULL)</td>
          <td class="col6">92,42</td>
        </tr>
        <tr>
          <td class="col0">1994-11-01</td>
          <td class="col1">11,0</td>
          <td class="col2">101,22</td>
          <td class="col3">1994</td>
          <td class="col4">11</td>
          <td class="col5">(NULL)</td>
          <td class="col6">101,22</td>
        </tr>
        <tr>
          <td class="col0">1994-12-01</td>
          <td class="col1">11,0</td>
          <td class="col2">234,71</td>
          <td class="col3">1994</td>
          <td class="col4">12</td>
          <td class="col5">(NULL)</td>
          <td class="col6">234,71</td>
        </tr>
        <tr>
          <td class="col0">1995-01-01</td>
          <td class="col1">11,0</td>
          <td class="col2">109,38</td>
          <td class="col3">1995</td>
          <td class="col4">1</td>
          <td class="col5">(NULL)</td>
          <td class="col6">109,38</td>
        </tr>
        <tr>
          <td class="col0">1995-02-01</td>
          <td class="col1">11,0</td>
          <td class="col2">109,38</td>
          <td class="col3">1995</td>
          <td class="col4">2</td>
          <td class="col5">(NULL)</td>
          <td class="col6">109,38</td>
        </tr>
        <tr>
          <td class="col0">1995-03-01</td>
          <td class="col1">11,0</td>
          <td class="col2">109,38</td>
          <td class="col3">1995</td>
          <td class="col4">3</td>
          <td class="col5">(NULL)</td>
          <td class="col6">109,38</td>
        </tr>
        <tr>
          <td class="col0">1995-04-01</td>
          <td class="col1">11,0</td>
          <td class="col2">109,38</td>
          <td class="col3">1995</td>
          <td class="col4">4</td>
          <td class="col5">(NULL)</td>
          <td class="col6">109,38</td>
        </tr>
        <tr>
          <td class="col0">1995-05-01</td>
          <td class="col1">11,0</td>
          <td class="col2">119,32</td>
          <td class="col3">1995</td>
          <td class="col4">5</td>
          <td class="col5">(NULL)</td>
          <td class="col6">119,32</td>
        </tr>
        <tr>
          <td class="col0">1995-06-01</td>
          <td class="col1">11,0</td>
          <td class="col2">126,28</td>
          <td class="col3">1995</td>
          <td class="col4">6</td>
          <td class="col5">(NULL)</td>
          <td class="col6">126,28</td>
        </tr>
        <tr>
          <td class="col0">1995-07-01</td>
          <td class="col1">11,0</td>
          <td class="col2">126,28</td>
          <td class="col3">1995</td>
          <td class="col4">7</td>
          <td class="col5">(NULL)</td>
          <td class="col6">126,28</td>
        </tr>
        <tr>
          <td class="col0">1995-08-01</td>
          <td class="col1">11,0</td>
          <td class="col2">37,8</td>
          <td class="col3">1995</td>
          <td class="col4">8</td>
          <td class="col5">(NULL)</td>
          <td class="col6">37,8</td>
        </tr>
        <tr>
          <td class="col0">1996-02-01</td>
          <td class="col1">11,0</td>
          <td class="col2">87,02</td>
          <td class="col3">1996</td>
          <td class="col4">2</td>
          <td class="col5">(NULL)</td>
          <td class="col6">87,02</td>
        </tr>
        <tr>
          <td class="col0">1996-03-01</td>
          <td class="col1">11,0</td>
          <td class="col2">130,53</td>
          <td class="col3">1996</td>
          <td class="col4">3</td>
          <td class="col5">(NULL)</td>
          <td class="col6">130,53</td>
        </tr>
        <tr>
          <td class="col0">1996-04-01</td>
          <td class="col1">11,0</td>
          <td class="col2">130,53</td>
          <td class="col3">1996</td>
          <td class="col4">4</td>
          <td class="col5">(NULL)</td>
          <td class="col6">130,53</td>
        </tr>
        <tr>
          <td class="col0">1996-05-01</td>
          <td class="col1">11,0</td>
          <td class="col2">146,19</td>
          <td class="col3">1996</td>
          <td class="col4">5</td>
          <td class="col5">(NULL)</td>
          <td class="col6">146,19</td>
        </tr>
        <tr>
          <td class="col0">1996-06-01</td>
          <td class="col1">11,0</td>
          <td class="col2">146,19</td>
          <td class="col3">1996</td>
          <td class="col4">6</td>
          <td class="col5">(NULL)</td>
          <td class="col6">146,19</td>
        </tr>
        <tr>
          <td class="col0">1996-07-01</td>
          <td class="col1">11,0</td>
          <td class="col2">146,19</td>
          <td class="col3">1996</td>
          <td class="col4">7</td>
          <td class="col5">(NULL)</td>
          <td class="col6">146,19</td>
        </tr>
        <tr>
          <td class="col0">1996-08-01</td>
          <td class="col1">11,0</td>
          <td class="col2">146,19</td>
          <td class="col3">1996</td>
          <td class="col4">8</td>
          <td class="col5">(NULL)</td>
          <td class="col6">146,19</td>
        </tr>
        <tr>
          <td class="col0">1996-09-01</td>
          <td class="col1">11,0</td>
          <td class="col2">146,19</td>
          <td class="col3">1996</td>
          <td class="col4">9</td>
          <td class="col5">(NULL)</td>
          <td class="col6">146,19</td>
        </tr>
        <tr>
          <td class="col0">1996-10-01</td>
          <td class="col1">11,0</td>
          <td class="col2">146,19</td>
          <td class="col3">1996</td>
          <td class="col4">10</td>
          <td class="col5">(NULL)</td>
          <td class="col6">146,19</td>
        </tr>
        <tr>
          <td class="col0">1996-11-01</td>
          <td class="col1">11,0</td>
          <td class="col2">146,19</td>
          <td class="col3">1996</td>
          <td class="col4">11</td>
          <td class="col5">(NULL)</td>
          <td class="col6">146,19</td>
        </tr>
        <tr>
          <td class="col0">1996-12-01</td>
          <td class="col1">11,0</td>
          <td class="col2">292,38</td>
          <td class="col3">1996</td>
          <td class="col4">12</td>
          <td class="col5">(NULL)</td>
          <td class="col6">292,38</td>
        </tr>
        <tr>
          <td class="col0">1996-12-01</td>
          <td class="col1">11,0</td>
          <td class="col2">0,0</td>
          <td class="col3">1996</td>
          <td class="col4">13</td>
          <td class="col5">(NULL)</td>
          <td class="col6">0,0</td>
        </tr>
        <tr>
          <td class="col0">1997-01-01</td>
          <td class="col1">11,0</td>
          <td class="col2">146,19</td>
          <td class="col3">1997</td>
          <td class="col4">1</td>
          <td class="col5">(NULL)</td>
          <td class="col6">146,19</td>
        </tr>
        <tr>
          <td class="col0">1997-02-01</td>
          <td class="col1">11,0</td>
          <td class="col2">146,19</td>
          <td class="col3">1997</td>
          <td class="col4">2</td>
          <td class="col5">(NULL)</td>
          <td class="col6">146,19</td>
        </tr>
        <tr>
          <td class="col0">1997-03-01</td>
          <td class="col1">11,0</td>
          <td class="col2">146,19</td>
          <td class="col3">1997</td>
          <td class="col4">3</td>
          <td class="col5">(NULL)</td>
          <td class="col6">146,19</td>
        </tr>
        <tr>
          <td class="col0">1997-04-01</td>
          <td class="col1">11,0</td>
          <td class="col2">146,19</td>
          <td class="col3">1997</td>
          <td class="col4">4</td>
          <td class="col5">(NULL)</td>
          <td class="col6">146,19</td>
        </tr>
        <tr>
          <td class="col0">1997-05-01</td>
          <td class="col1">11,0</td>
          <td class="col2">146,19</td>
          <td class="col3">1997</td>
          <td class="col4">5</td>
          <td class="col5">(NULL)</td>
          <td class="col6">146,19</td>
        </tr>
        <tr>
          <td class="col0">1997-06-01</td>
          <td class="col1">11,0</td>
          <td class="col2">146,19</td>
          <td class="col3">1997</td>
          <td class="col4">6</td>
          <td class="col5">(NULL)</td>
          <td class="col6">146,19</td>
        </tr>
        <tr>
          <td class="col0">1997-07-01</td>
          <td class="col1">11,0</td>
          <td class="col2">146,19</td>
          <td class="col3">1997</td>
          <td class="col4">7</td>
          <td class="col5">(NULL)</td>
          <td class="col6">146,19</td>
        </tr>
        <tr>
          <td class="col0">1997-08-01</td>
          <td class="col1">11,0</td>
          <td class="col2">146,19</td>
          <td class="col3">1997</td>
          <td class="col4">8</td>
          <td class="col5">(NULL)</td>
          <td class="col6">146,19</td>
        </tr>
        <tr>
          <td class="col0">1997-09-01</td>
          <td class="col1">11,0</td>
          <td class="col2">146,19</td>
          <td class="col3">1997</td>
          <td class="col4">9</td>
          <td class="col5">(NULL)</td>
          <td class="col6">146,19</td>
        </tr>
        <tr>
          <td class="col0">1997-10-01</td>
          <td class="col1">11,0</td>
          <td class="col2">146,19</td>
          <td class="col3">1997</td>
          <td class="col4">10</td>
          <td class="col5">(NULL)</td>
          <td class="col6">146,19</td>
        </tr>
        <tr>
          <td class="col0">1997-11-01</td>
          <td class="col1">11,0</td>
          <td class="col2">146,19</td>
          <td class="col3">1997</td>
          <td class="col4">11</td>
          <td class="col5">(NULL)</td>
          <td class="col6">146,19</td>
        </tr>
        <tr>
          <td class="col0">1997-12-01</td>
          <td class="col1">11,0</td>
          <td class="col2">292,38</td>
          <td class="col3">1997</td>
          <td class="col4">12</td>
          <td class="col5">(NULL)</td>
          <td class="col6">292,38</td>
        </tr>
        <tr>
          <td class="col0">1998-01-01</td>
          <td class="col1">11,0</td>
          <td class="col2">149,12</td>
          <td class="col3">1998</td>
          <td class="col4">1</td>
          <td class="col5">(NULL)</td>
          <td class="col6">149,12</td>
        </tr>
        <tr>
          <td class="col0">1998-02-01</td>
          <td class="col1">11,0</td>
          <td class="col2">149,12</td>
          <td class="col3">1998</td>
          <td class="col4">2</td>
          <td class="col5">(NULL)</td>
          <td class="col6">149,12</td>
        </tr>
        <tr>
          <td class="col0">1998-03-01</td>
          <td class="col1">11,0</td>
          <td class="col2">149,12</td>
          <td class="col3">1998</td>
          <td class="col4">3</td>
          <td class="col5">(NULL)</td>
          <td class="col6">149,12</td>
        </tr>
        <tr>
          <td class="col0">1998-04-01</td>
          <td class="col1">11,0</td>
          <td class="col2">149,12</td>
          <td class="col3">1998</td>
          <td class="col4">4</td>
          <td class="col5">(NULL)</td>
          <td class="col6">149,12</td>
        </tr>
        <tr>
          <td class="col0">1998-05-01</td>
          <td class="col1">11,0</td>
          <td class="col2">149,11</td>
          <td class="col3">1998</td>
          <td class="col4">5</td>
          <td class="col5">(NULL)</td>
          <td class="col6">149,11</td>
        </tr>
        <tr>
          <td class="col0">1998-06-01</td>
          <td class="col1">11,0</td>
          <td class="col2">149,11</td>
          <td class="col3">1998</td>
          <td class="col4">6</td>
          <td class="col5">(NULL)</td>
          <td class="col6">149,11</td>
        </tr>
        <tr>
          <td class="col0">1998-07-01</td>
          <td class="col1">11,0</td>
          <td class="col2">198,81</td>
          <td class="col3">1998</td>
          <td class="col4">7</td>
          <td class="col5">(NULL)</td>
          <td class="col6">198,81</td>
        </tr>
        <tr>
          <td class="col0">1998-08-01</td>
          <td class="col1">11,0</td>
          <td class="col2">149,11</td>
          <td class="col3">1998</td>
          <td class="col4">8</td>
          <td class="col5">(NULL)</td>
          <td class="col6">149,11</td>
        </tr>
        <tr>
          <td class="col0">1998-09-01</td>
          <td class="col1">11,0</td>
          <td class="col2">149,11</td>
          <td class="col3">1998</td>
          <td class="col4">9</td>
          <td class="col5">(NULL)</td>
          <td class="col6">149,11</td>
        </tr>
        <tr>
          <td class="col0">1998-10-01</td>
          <td class="col1">11,0</td>
          <td class="col2">149,11</td>
          <td class="col3">1998</td>
          <td class="col4">10</td>
          <td class="col5">(NULL)</td>
          <td class="col6">149,11</td>
        </tr>
        <tr>
          <td class="col0">1998-11-01</td>
          <td class="col1">11,0</td>
          <td class="col2">149,11</td>
          <td class="col3">1998</td>
          <td class="col4">11</td>
          <td class="col5">(NULL)</td>
          <td class="col6">149,11</td>
        </tr>
        <tr>
          <td class="col0">1998-12-01</td>
          <td class="col1">11,0</td>
          <td class="col2">298,22</td>
          <td class="col3">1998</td>
          <td class="col4">12</td>
          <td class="col5">(NULL)</td>
          <td class="col6">298,22</td>
        </tr>
        <tr>
          <td class="col0">1999-01-01</td>
          <td class="col1">11,0</td>
          <td class="col2">150,24</td>
          <td class="col3">1999</td>
          <td class="col4">1</td>
          <td class="col5">(NULL)</td>
          <td class="col6">150,24</td>
        </tr>
        <tr>
          <td class="col0">1999-02-01</td>
          <td class="col1">11,0</td>
          <td class="col2">150,24</td>
          <td class="col3">1999</td>
          <td class="col4">2</td>
          <td class="col5">(NULL)</td>
          <td class="col6">150,24</td>
        </tr>
        <tr>
          <td class="col0">1999-03-01</td>
          <td class="col1">11,0</td>
          <td class="col2">150,24</td>
          <td class="col3">1999</td>
          <td class="col4">3</td>
          <td class="col5">(NULL)</td>
          <td class="col6">150,24</td>
        </tr>
        <tr>
          <td class="col0">1999-04-01</td>
          <td class="col1">11,0</td>
          <td class="col2">150,24</td>
          <td class="col3">1999</td>
          <td class="col4">4</td>
          <td class="col5">(NULL)</td>
          <td class="col6">150,24</td>
        </tr>
        <tr>
          <td class="col0">1999-05-01</td>
          <td class="col1">11,0</td>
          <td class="col2">225,37</td>
          <td class="col3">1999</td>
          <td class="col4">5</td>
          <td class="col5">(NULL)</td>
          <td class="col6">225,37</td>
        </tr>
        <tr>
          <td class="col0">1999-06-01</td>
          <td class="col1">11,0</td>
          <td class="col2">150,13</td>
          <td class="col3">1999</td>
          <td class="col4">6</td>
          <td class="col5">(NULL)</td>
          <td class="col6">150,13</td>
        </tr>
        <tr>
          <td class="col0">1999-07-01</td>
          <td class="col1">11,0</td>
          <td class="col2">233,7</td>
          <td class="col3">1999</td>
          <td class="col4">7</td>
          <td class="col5">(NULL)</td>
          <td class="col6">233,7</td>
        </tr>
        <tr>
          <td class="col0">1999-08-01</td>
          <td class="col1">11,0</td>
          <td class="col2">175,28</td>
          <td class="col3">1999</td>
          <td class="col4">8</td>
          <td class="col5">(NULL)</td>
          <td class="col6">175,28</td>
        </tr>
        <tr>
          <td class="col0">1999-09-01</td>
          <td class="col1">11,0</td>
          <td class="col2">175,28</td>
          <td class="col3">1999</td>
          <td class="col4">9</td>
          <td class="col5">(NULL)</td>
          <td class="col6">175,28</td>
        </tr>
        <tr>
          <td class="col0">1999-10-01</td>
          <td class="col1">11,0</td>
          <td class="col2">250,19</td>
          <td class="col3">1999</td>
          <td class="col4">10</td>
          <td class="col5">(NULL)</td>
          <td class="col6">250,19</td>
        </tr>
        <tr>
          <td class="col0">1999-11-01</td>
          <td class="col1">11,0</td>
          <td class="col2">252,15</td>
          <td class="col3">1999</td>
          <td class="col4">11</td>
          <td class="col5">(NULL)</td>
          <td class="col6">252,15</td>
        </tr>
        <tr>
          <td class="col0">1999-12-01</td>
          <td class="col1">11,0</td>
          <td class="col2">504,3</td>
          <td class="col3">1999</td>
          <td class="col4">12</td>
          <td class="col5">(NULL)</td>
          <td class="col6">504,3</td>
        </tr>
        <tr>
          <td class="col0">2000-01-01</td>
          <td class="col1">11,0</td>
          <td class="col2">252,15</td>
          <td class="col3">2000</td>
          <td class="col4">1</td>
          <td class="col5">(NULL)</td>
          <td class="col6">252,15</td>
        </tr>
        <tr>
          <td class="col0">2000-02-01</td>
          <td class="col1">11,0</td>
          <td class="col2">252,15</td>
          <td class="col3">2000</td>
          <td class="col4">2</td>
          <td class="col5">(NULL)</td>
          <td class="col6">252,15</td>
        </tr>
        <tr>
          <td class="col0">2000-03-01</td>
          <td class="col1">11,0</td>
          <td class="col2">252,15</td>
          <td class="col3">2000</td>
          <td class="col4">3</td>
          <td class="col5">(NULL)</td>
          <td class="col6">252,15</td>
        </tr>
        <tr>
          <td class="col0">2000-04-01</td>
          <td class="col1">11,0</td>
          <td class="col2">252,15</td>
          <td class="col3">2000</td>
          <td class="col4">4</td>
          <td class="col5">(NULL)</td>
          <td class="col6">252,15</td>
        </tr>
        <tr>
          <td class="col0">2000-05-01</td>
          <td class="col1">11,0</td>
          <td class="col2">287,87</td>
          <td class="col3">2000</td>
          <td class="col4">5</td>
          <td class="col5">(NULL)</td>
          <td class="col6">287,87</td>
        </tr>
        <tr>
          <td class="col0">2000-06-01</td>
          <td class="col1">11,0</td>
          <td class="col2">383,82</td>
          <td class="col3">2000</td>
          <td class="col4">6</td>
          <td class="col5">(NULL)</td>
          <td class="col6">383,82</td>
        </tr>
        <tr>
          <td class="col0">2000-08-01</td>
          <td class="col1">11,0</td>
          <td class="col2">287,87</td>
          <td class="col3">2000</td>
          <td class="col4">8</td>
          <td class="col5">(NULL)</td>
          <td class="col6">287,87</td>
        </tr>
        <tr>
          <td class="col0">2000-09-01</td>
          <td class="col1">11,0</td>
          <td class="col2">287,87</td>
          <td class="col3">2000</td>
          <td class="col4">9</td>
          <td class="col5">(NULL)</td>
          <td class="col6">287,87</td>
        </tr>
        <tr>
          <td class="col0">2000-10-01</td>
          <td class="col1">11,0</td>
          <td class="col2">204,87</td>
          <td class="col3">2000</td>
          <td class="col4">10</td>
          <td class="col5">(NULL)</td>
          <td class="col6">204,87</td>
        </tr>
        <tr>
          <td class="col0">2000-11-01</td>
          <td class="col1">11,0</td>
          <td class="col2">290,11</td>
          <td class="col3">2000</td>
          <td class="col4">11</td>
          <td class="col5">(NULL)</td>
          <td class="col6">290,11</td>
        </tr>
        <tr>
          <td class="col0">2000-12-01</td>
          <td class="col1">11,0</td>
          <td class="col2">580,22</td>
          <td class="col3">2000</td>
          <td class="col4">12</td>
          <td class="col5">(NULL)</td>
          <td class="col6">580,22</td>
        </tr>
        <tr>
          <td class="col0">2001-01-01</td>
          <td class="col1">11,0</td>
          <td class="col2">290,11</td>
          <td class="col3">2001</td>
          <td class="col4">1</td>
          <td class="col5">(NULL)</td>
          <td class="col6">290,11</td>
        </tr>
        <tr>
          <td class="col0">2001-02-01</td>
          <td class="col1">11,0</td>
          <td class="col2">386,81</td>
          <td class="col3">2001</td>
          <td class="col4">2</td>
          <td class="col5">(NULL)</td>
          <td class="col6">386,81</td>
        </tr>
        <tr>
          <td class="col0">2001-03-01</td>
          <td class="col1">11,0</td>
          <td class="col2">290,11</td>
          <td class="col3">2001</td>
          <td class="col4">3</td>
          <td class="col5">(NULL)</td>
          <td class="col6">290,11</td>
        </tr>
        <tr>
          <td class="col0">2001-04-01</td>
          <td class="col1">11,0</td>
          <td class="col2">290,11</td>
          <td class="col3">2001</td>
          <td class="col4">4</td>
          <td class="col5">(NULL)</td>
          <td class="col6">290,11</td>
        </tr>
        <tr>
          <td class="col0">2001-05-01</td>
          <td class="col1">11,0</td>
          <td class="col2">290,11</td>
          <td class="col3">2001</td>
          <td class="col4">5</td>
          <td class="col5">(NULL)</td>
          <td class="col6">290,11</td>
        </tr>
        <tr>
          <td class="col0">2001-06-01</td>
          <td class="col1">11,0</td>
          <td class="col2">290,11</td>
          <td class="col3">2001</td>
          <td class="col4">6</td>
          <td class="col5">(NULL)</td>
          <td class="col6">290,11</td>
        </tr>
        <tr>
          <td class="col0">2001-07-01</td>
          <td class="col1">11,0</td>
          <td class="col2">435,04</td>
          <td class="col3">2001</td>
          <td class="col4">7</td>
          <td class="col5">(NULL)</td>
          <td class="col6">435,04</td>
        </tr>
        <tr>
          <td class="col0">2001-08-01</td>
          <td class="col1">11,0</td>
          <td class="col2">290,11</td>
          <td class="col3">2001</td>
          <td class="col4">8</td>
          <td class="col5">(NULL)</td>
          <td class="col6">290,11</td>
        </tr>
        <tr>
          <td class="col0">2001-09-01</td>
          <td class="col1">11,0</td>
          <td class="col2">290,11</td>
          <td class="col3">2001</td>
          <td class="col4">9</td>
          <td class="col5">(NULL)</td>
          <td class="col6">290,11</td>
        </tr>
        <tr>
          <td class="col0">2001-10-01</td>
          <td class="col1">11,0</td>
          <td class="col2">290,11</td>
          <td class="col3">2001</td>
          <td class="col4">10</td>
          <td class="col5">(NULL)</td>
          <td class="col6">290,11</td>
        </tr>
        <tr>
          <td class="col0">2001-11-01</td>
          <td class="col1">11,0</td>
          <td class="col2">389,78</td>
          <td class="col3">2001</td>
          <td class="col4">11</td>
          <td class="col5">(NULL)</td>
          <td class="col6">389,78</td>
        </tr>
        <tr>
          <td class="col0">2001-12-01</td>
          <td class="col1">11,0</td>
          <td class="col2">439,64</td>
          <td class="col3">2001</td>
          <td class="col4">12</td>
          <td class="col5">(NULL)</td>
          <td class="col6">439,64</td>
        </tr>
        <tr>
          <td class="col0">2002-01-01</td>
          <td class="col1">11,0</td>
          <td class="col2">292,34</td>
          <td class="col3">2002</td>
          <td class="col4">1</td>
          <td class="col5">(NULL)</td>
          <td class="col6">292,34</td>
        </tr>
        <tr>
          <td class="col0">2002-02-01</td>
          <td class="col1">11,0</td>
          <td class="col2">292,34</td>
          <td class="col3">2002</td>
          <td class="col4">2</td>
          <td class="col5">(NULL)</td>
          <td class="col6">292,34</td>
        </tr>
        <tr>
          <td class="col0">2002-03-01</td>
          <td class="col1">11,0</td>
          <td class="col2">292,34</td>
          <td class="col3">2002</td>
          <td class="col4">3</td>
          <td class="col5">(NULL)</td>
          <td class="col6">292,34</td>
        </tr>
        <tr>
          <td class="col0">2002-04-01</td>
          <td class="col1">11,0</td>
          <td class="col2">292,34</td>
          <td class="col3">2002</td>
          <td class="col4">4</td>
          <td class="col5">(NULL)</td>
          <td class="col6">292,34</td>
        </tr>
        <tr>
          <td class="col0">2002-05-01</td>
          <td class="col1">11,0</td>
          <td class="col2">292,34</td>
          <td class="col3">2002</td>
          <td class="col4">5</td>
          <td class="col5">(NULL)</td>
          <td class="col6">292,34</td>
        </tr>
        <tr>
          <td class="col0">2002-06-01</td>
          <td class="col1">11,0</td>
          <td class="col2">516,41</td>
          <td class="col3">2002</td>
          <td class="col4">6</td>
          <td class="col5">(NULL)</td>
          <td class="col6">516,41</td>
        </tr>
        <tr>
          <td class="col0">2002-07-01</td>
          <td class="col1">11,0</td>
          <td class="col2">370,25</td>
          <td class="col3">2002</td>
          <td class="col4">7</td>
          <td class="col5">(NULL)</td>
          <td class="col6">370,25</td>
        </tr>
        <tr>
          <td class="col0">2002-08-01</td>
          <td class="col1">11,0</td>
          <td class="col2">370,25</td>
          <td class="col3">2002</td>
          <td class="col4">8</td>
          <td class="col5">(NULL)</td>
          <td class="col6">370,25</td>
        </tr>
        <tr>
          <td class="col0">2002-09-01</td>
          <td class="col1">11,0</td>
          <td class="col2">370,25</td>
          <td class="col3">2002</td>
          <td class="col4">9</td>
          <td class="col5">(NULL)</td>
          <td class="col6">370,25</td>
        </tr>
        <tr>
          <td class="col0">2002-10-01</td>
          <td class="col1">11,0</td>
          <td class="col2">506,89</td>
          <td class="col3">2002</td>
          <td class="col4">10</td>
          <td class="col5">(NULL)</td>
          <td class="col6">506,89</td>
        </tr>
        <tr>
          <td class="col0">2002-11-01</td>
          <td class="col1">11,0</td>
          <td class="col2">1017,56</td>
          <td class="col3">2002</td>
          <td class="col4">11</td>
          <td class="col5">(NULL)</td>
          <td class="col6">1017,56</td>
        </tr>
        <tr>
          <td class="col0">2002-12-01</td>
          <td class="col1">11,0</td>
          <td class="col2">1045,45</td>
          <td class="col3">2002</td>
          <td class="col4">12</td>
          <td class="col5">(NULL)</td>
          <td class="col6">1045,45</td>
        </tr>
        <tr>
          <td class="col0">2003-01-01</td>
          <td class="col1">11,0</td>
          <td class="col2">510,74</td>
          <td class="col3">2003</td>
          <td class="col4">1</td>
          <td class="col5">(NULL)</td>
          <td class="col6">510,74</td>
        </tr>
        <tr>
          <td class="col0">2003-02-01</td>
          <td class="col1">11,0</td>
          <td class="col2">510,74</td>
          <td class="col3">2003</td>
          <td class="col4">2</td>
          <td class="col5">(NULL)</td>
          <td class="col6">510,74</td>
        </tr>
        <tr>
          <td class="col0">2003-03-01</td>
          <td class="col1">11,0</td>
          <td class="col2">510,74</td>
          <td class="col3">2003</td>
          <td class="col4">3</td>
          <td class="col5">(NULL)</td>
          <td class="col6">510,74</td>
        </tr>
        <tr>
          <td class="col0">2003-04-01</td>
          <td class="col1">11,0</td>
          <td class="col2">510,74</td>
          <td class="col3">2003</td>
          <td class="col4">4</td>
          <td class="col5">(NULL)</td>
          <td class="col6">510,74</td>
        </tr>
        <tr>
          <td class="col0">2003-05-01</td>
          <td class="col1">11,0</td>
          <td class="col2">510,74</td>
          <td class="col3">2003</td>
          <td class="col4">5</td>
          <td class="col5">(NULL)</td>
          <td class="col6">510,74</td>
        </tr>
        <tr>
          <td class="col0">2003-06-01</td>
          <td class="col1">11,0</td>
          <td class="col2">1021,48</td>
          <td class="col3">2003</td>
          <td class="col4">6</td>
          <td class="col5">(NULL)</td>
          <td class="col6">1021,48</td>
        </tr>
        <tr>
          <td class="col0">2003-07-01</td>
          <td class="col1">11,0</td>
          <td class="col2">510,74</td>
          <td class="col3">2003</td>
          <td class="col4">7</td>
          <td class="col5">(NULL)</td>
          <td class="col6">510,74</td>
        </tr>
        <tr>
          <td class="col0">2003-08-01</td>
          <td class="col1">11,0</td>
          <td class="col2">510,74</td>
          <td class="col3">2003</td>
          <td class="col4">8</td>
          <td class="col5">(NULL)</td>
          <td class="col6">510,74</td>
        </tr>
        <tr>
          <td class="col0">2003-09-01</td>
          <td class="col1">11,0</td>
          <td class="col2">510,74</td>
          <td class="col3">2003</td>
          <td class="col4">9</td>
          <td class="col5">(NULL)</td>
          <td class="col6">510,74</td>
        </tr>
        <tr>
          <td class="col0">2003-10-01</td>
          <td class="col1">11,0</td>
          <td class="col2">510,74</td>
          <td class="col3">2003</td>
          <td class="col4">10</td>
          <td class="col5">(NULL)</td>
          <td class="col6">510,74</td>
        </tr>
        <tr>
          <td class="col0">2003-11-01</td>
          <td class="col1">11,0</td>
          <td class="col2">514,6</td>
          <td class="col3">2003</td>
          <td class="col4">11</td>
          <td class="col5">(NULL)</td>
          <td class="col6">514,6</td>
        </tr>
        <tr>
          <td class="col0">2003-12-01</td>
          <td class="col1">11,0</td>
          <td class="col2">1200,73</td>
          <td class="col3">2003</td>
          <td class="col4">12</td>
          <td class="col5">(NULL)</td>
          <td class="col6">1200,73</td>
        </tr>
        <tr>
          <td class="col0">2004-01-01</td>
          <td class="col1">11,0</td>
          <td class="col2">514,6</td>
          <td class="col3">2004</td>
          <td class="col4">1</td>
          <td class="col5">(NULL)</td>
          <td class="col6">514,6</td>
        </tr>
        <tr>
          <td class="col0">2004-02-01</td>
          <td class="col1">11,0</td>
          <td class="col2">512,84</td>
          <td class="col3">2004</td>
          <td class="col4">2</td>
          <td class="col5">(NULL)</td>
          <td class="col6">512,84</td>
        </tr>
        <tr>
          <td class="col0">2004-03-01</td>
          <td class="col1">11,0</td>
          <td class="col2">514,6</td>
          <td class="col3">2004</td>
          <td class="col4">3</td>
          <td class="col5">(NULL)</td>
          <td class="col6">514,6</td>
        </tr>
        <tr>
          <td class="col0">2004-04-01</td>
          <td class="col1">11,0</td>
          <td class="col2">514,6</td>
          <td class="col3">2004</td>
          <td class="col4">4</td>
          <td class="col5">(NULL)</td>
          <td class="col6">514,6</td>
        </tr>
        <tr>
          <td class="col0">2004-05-01</td>
          <td class="col1">11,0</td>
          <td class="col2">1029,2</td>
          <td class="col3">2004</td>
          <td class="col4">5</td>
          <td class="col5">(NULL)</td>
          <td class="col6">1029,2</td>
        </tr>
        <tr>
          <td class="col0">2004-06-01</td>
          <td class="col1">11,0</td>
          <td class="col2">514,56</td>
          <td class="col3">2004</td>
          <td class="col4">6</td>
          <td class="col5">0,0</td>
          <td class="col6">514,56</td>
        </tr>
        <tr>
          <td class="col0">2004-07-01</td>
          <td class="col1">11,0</td>
          <td class="col2">514,56</td>
          <td class="col3">2004</td>
          <td class="col4">7</td>
          <td class="col5">(NULL)</td>
          <td class="col6">514,56</td>
        </tr>
        <tr>
          <td class="col0">2004-08-01</td>
          <td class="col1">11,0</td>
          <td class="col2">514,56</td>
          <td class="col3">2004</td>
          <td class="col4">8</td>
          <td class="col5">(NULL)</td>
          <td class="col6">514,56</td>
        </tr>
        <tr>
          <td class="col0">2004-09-01</td>
          <td class="col1">11,0</td>
          <td class="col2">514,56</td>
          <td class="col3">2004</td>
          <td class="col4">9</td>
          <td class="col5">(NULL)</td>
          <td class="col6">514,56</td>
        </tr>
        <tr>
          <td class="col0">2004-10-01</td>
          <td class="col1">11,0</td>
          <td class="col2">514,56</td>
          <td class="col3">2004</td>
          <td class="col4">10</td>
          <td class="col5">(NULL)</td>
          <td class="col6">514,56</td>
        </tr>
        <tr>
          <td class="col0">2004-11-01</td>
          <td class="col1">11,0</td>
          <td class="col2">518,45</td>
          <td class="col3">2004</td>
          <td class="col4">11</td>
          <td class="col5">(NULL)</td>
          <td class="col6">518,45</td>
        </tr>
        <tr>
          <td class="col0">2004-12-01</td>
          <td class="col1">11,0</td>
          <td class="col2">691,27</td>
          <td class="col3">2004</td>
          <td class="col4">12</td>
          <td class="col5">(NULL)</td>
          <td class="col6">691,27</td>
        </tr>
        <tr>
          <td class="col0">2005-01-01</td>
          <td class="col1">11,0</td>
          <td class="col2">558,77</td>
          <td class="col3">2005</td>
          <td class="col4">1</td>
          <td class="col5">(NULL)</td>
          <td class="col6">558,77</td>
        </tr>
        <tr>
          <td class="col0">2005-02-01</td>
          <td class="col1">11,0</td>
          <td class="col2">518,46</td>
          <td class="col3">2005</td>
          <td class="col4">2</td>
          <td class="col5">(NULL)</td>
          <td class="col6">518,46</td>
        </tr>
        <tr>
          <td class="col0">2005-03-01</td>
          <td class="col1">11,0</td>
          <td class="col2">514,56</td>
          <td class="col3">2005</td>
          <td class="col4">3</td>
          <td class="col5">(NULL)</td>
          <td class="col6">514,56</td>
        </tr>
        <tr>
          <td class="col0">2005-04-01</td>
          <td class="col1">11,0</td>
          <td class="col2">514,56</td>
          <td class="col3">2005</td>
          <td class="col4">4</td>
          <td class="col5">(NULL)</td>
          <td class="col6">514,56</td>
        </tr>
        <tr>
          <td class="col0">2005-05-01</td>
          <td class="col1">11,0</td>
          <td class="col2">559,93</td>
          <td class="col3">2005</td>
          <td class="col4">5</td>
          <td class="col5">(NULL)</td>
          <td class="col6">559,93</td>
        </tr>
        <tr>
          <td class="col0">2005-06-01</td>
          <td class="col1">11,0</td>
          <td class="col2">559,93</td>
          <td class="col3">2005</td>
          <td class="col4">6</td>
          <td class="col5">(NULL)</td>
          <td class="col6">559,93</td>
        </tr>
        <tr>
          <td class="col0">2005-07-01</td>
          <td class="col1">11,0</td>
          <td class="col2">559,93</td>
          <td class="col3">2005</td>
          <td class="col4">7</td>
          <td class="col5">(NULL)</td>
          <td class="col6">559,93</td>
        </tr>
        <tr>
          <td class="col0">2005-08-01</td>
          <td class="col1">11,0</td>
          <td class="col2">559,93</td>
          <td class="col3">2005</td>
          <td class="col4">8</td>
          <td class="col5">(NULL)</td>
          <td class="col6">559,93</td>
        </tr>
        <tr>
          <td class="col0">2005-09-01</td>
          <td class="col1">11,0</td>
          <td class="col2">559,93</td>
          <td class="col3">2005</td>
          <td class="col4">9</td>
          <td class="col5">(NULL)</td>
          <td class="col6">559,93</td>
        </tr>
        <tr>
          <td class="col0">2005-10-01</td>
          <td class="col1">11,0</td>
          <td class="col2">559,93</td>
          <td class="col3">2005</td>
          <td class="col4">10</td>
          <td class="col5">(NULL)</td>
          <td class="col6">559,93</td>
        </tr>
        <tr>
          <td class="col0">2005-11-01</td>
          <td class="col1">11,0</td>
          <td class="col2">564,1</td>
          <td class="col3">2005</td>
          <td class="col4">11</td>
          <td class="col5">(NULL)</td>
          <td class="col6">564,1</td>
        </tr>
        <tr>
          <td class="col0">2005-12-01</td>
          <td class="col1">11,0</td>
          <td class="col2">1128,2</td>
          <td class="col3">2005</td>
          <td class="col4">12</td>
          <td class="col5">(NULL)</td>
          <td class="col6">1128,2</td>
        </tr>
        <tr>
          <td class="col0">2006-01-01</td>
          <td class="col1">11,0</td>
          <td class="col2">752,13</td>
          <td class="col3">2006</td>
          <td class="col4">1</td>
          <td class="col5">(NULL)</td>
          <td class="col6">752,13</td>
        </tr>
        <tr>
          <td class="col0">2006-02-01</td>
          <td class="col1">11,0</td>
          <td class="col2">564,1</td>
          <td class="col3">2006</td>
          <td class="col4">2</td>
          <td class="col5">(NULL)</td>
          <td class="col6">564,1</td>
        </tr>
        <tr>
          <td class="col0">2006-03-01</td>
          <td class="col1">11,0</td>
          <td class="col2">564,1</td>
          <td class="col3">2006</td>
          <td class="col4">3</td>
          <td class="col5">(NULL)</td>
          <td class="col6">564,1</td>
        </tr>
        <tr>
          <td class="col0">2006-04-01</td>
          <td class="col1">11,0</td>
          <td class="col2">564,1</td>
          <td class="col3">2006</td>
          <td class="col4">4</td>
          <td class="col5">(NULL)</td>
          <td class="col6">564,1</td>
        </tr>
        <tr>
          <td class="col0">2006-05-01</td>
          <td class="col1">11,0</td>
          <td class="col2">1128,2</td>
          <td class="col3">2006</td>
          <td class="col4">5</td>
          <td class="col5">(NULL)</td>
          <td class="col6">1128,2</td>
        </tr>
        <tr>
          <td class="col0">2006-06-01</td>
          <td class="col1">11,0</td>
          <td class="col2">564,1</td>
          <td class="col3">2006</td>
          <td class="col4">6</td>
          <td class="col5">(NULL)</td>
          <td class="col6">564,1</td>
        </tr>
        <tr>
          <td class="col0">2006-07-01</td>
          <td class="col1">11,0</td>
          <td class="col2">575,4</td>
          <td class="col3">2006</td>
          <td class="col4">7</td>
          <td class="col5">(NULL)</td>
          <td class="col6">575,4</td>
        </tr>
        <tr>
          <td class="col0">2006-08-01</td>
          <td class="col1">11,0</td>
          <td class="col2">492,1</td>
          <td class="col3">2006</td>
          <td class="col4">8</td>
          <td class="col5">(NULL)</td>
          <td class="col6">492,1</td>
        </tr>
        <tr>
          <td class="col0">2006-09-01</td>
          <td class="col1">11,0</td>
          <td class="col2">492,1</td>
          <td class="col3">2006</td>
          <td class="col4">9</td>
          <td class="col5">(NULL)</td>
          <td class="col6">492,1</td>
        </tr>
        <tr>
          <td class="col0">2006-10-01</td>
          <td class="col1">11,0</td>
          <td class="col2">492,1</td>
          <td class="col3">2006</td>
          <td class="col4">10</td>
          <td class="col5">(NULL)</td>
          <td class="col6">492,1</td>
        </tr>
        <tr>
          <td class="col0">2006-11-01</td>
          <td class="col1">11,0</td>
          <td class="col2">495,73</td>
          <td class="col3">2006</td>
          <td class="col4">11</td>
          <td class="col5">(NULL)</td>
          <td class="col6">495,73</td>
        </tr>
        <tr>
          <td class="col0">2006-12-01</td>
          <td class="col1">11,0</td>
          <td class="col2">495,73</td>
          <td class="col3">2006</td>
          <td class="col4">12</td>
          <td class="col5">(NULL)</td>
          <td class="col6">495,73</td>
        </tr>
        <tr>
          <td class="col0">2007-01-01</td>
          <td class="col1">11,0</td>
          <td class="col2">661,45</td>
          <td class="col3">2007</td>
          <td class="col4">1</td>
          <td class="col5">(NULL)</td>
          <td class="col6">661,45</td>
        </tr>
        <tr>
          <td class="col0">2007-02-01</td>
          <td class="col1">11,0</td>
          <td class="col2">496,0</td>
          <td class="col3">2007</td>
          <td class="col4">2</td>
          <td class="col5">(NULL)</td>
          <td class="col6">496,0</td>
        </tr>
        <tr>
          <td class="col0">2007-03-01</td>
          <td class="col1">11,0</td>
          <td class="col2">496,0</td>
          <td class="col3">2007</td>
          <td class="col4">3</td>
          <td class="col5">(NULL)</td>
          <td class="col6">496,0</td>
        </tr>
      </tbody>
    </table>

    <p>
      <em>generated 15/12/2010 15:18:43      by <a href="http://www.heidisql.com/">HeidiSQL Version 4.0, Revision 2405</a></em>
    </p>

  </body>
</html>
#9