Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Help to buld complex query

1 view
Skip to first unread message

Henrique

unread,
Apr 25, 2010, 5:31:01 PM4/25/10
to
I have two tables:


Counters:' Every 10 minutes a record is added with updating the counter

Data_Hora ID_Contador E_SVazio
23-04-2010 0:00 CTE003 16.528.690
23-04-2010 0:00 CTE002 21.527.520
23-04-2010 0:10 CTE003 16.528.750
23-04-2010 0:10 CTE002 21.527.570
23-04-2010 1:20 CTE003 16.528.800
23-04-2010 1:20 CTE002 21.527.620
23-04-2010 1:30 CTE003 16.528.850
23-04-2010 1:30 CTE002 21.527.670
23-04-2010 2:40 CTE003 16.528.890
23-04-2010 2:40 CTE002 21.527.720


Data counters:
ID Nome Uni_Fab PT Zona Equipamento
CTE001 XPT0 Zebra PT1 Banhos Caixa1
CTE002 XPT1 Xoli PT2 Banhos Caixa2
CTE003 XPT2 Xoli PT1 Banhos Caixa3


Query:

SELECT
convert(varchar(2), contadores.Data_Hora, 108) as Hora,
Sum(MAX(E_SVazio) - MIN(E_SVazio)) as H_SVazio,

Contadores JOIN DadosContadores ON Contadores.ID_Contador =
DadosContadores.ID
WHERE
Year(Data_Hora)= 2010 AND Month(Data_Hora)= 4 AND Day(Data_Hora) = 23 And
E_SVazio<>0 AND Uni_Fab = 'Xoli'
GROUP BY
Year(Data_Hora),Month(Data_Hora),Day(Data_Hora),Convert(varchar(2),
contadores.Data_Hora, 108)
ORDER BY
Convert(varchar(2), contadores.Data_Hora, 108) Asc


This query d'ont whork whel

What I want is the sum of the energies, which is given by the difference of
two readings (Min and Max) to 23/04/2010 and Uni_Fab = Xoli grouping.


example:
"xoli" has two counters CTE002 and CTE003 and need to know the sum of these
two counts


someone help me?

Thanks

Se


0 new messages