Torna al Thread
SELECT YEAR(EVT_TARGET) anno,
MONTH(EVT_TARGET) mese,
UCO_DESC descr,
cast(datediff(mi,
(select T2.prv_dvalue from R5PROPERTYVALUES AS T2 where (T2.PRV_PROPERTY = 'UTNCIN' AND T2.prv_code = T1.prv_code)),
(select T3.prv_dvalue from R5PROPERTYVALUES AS T3 where (T3.PRV_PROPERTY = 'UTNCOUT' AND T3.prv_code = T1.prv_code))
)as float (2))/60 as ore
FROM R5EVENTS
INNER JOIN R5PROPERTYVALUES T1
ON PRV_CODE = EVT_CODE
INNER JOIN R5UCODES
ON UCO_CODE = EVT_JOBTYPE
WHERE (EVT_JOBTYPE = 'UTNTS' or EVT_JOBTYPE = 'UTNST' or EVT_JOBTYPE = 'UTNSU') and
EVT_TARGET >= DATEADD (day, -366, GETDATE())
and EVT_TARGEt >= '2013-01-05 00:00:00.000' and EVT_TARGEt <= '2013-31-05 00:00:00.000'
GROUP BY YEAR(EVT_TARGET), MONTH( EVT_TARGET ), UCO_DESC, T1.PRV_code
order by YEAR(EVT_TARGET) asc, MONTH(EVT_TARGET)