Torna al Thread
SELECT
YEAR(EVT_TARGET) anno,
MONTH(EVT_TARGET) mese,
UCO_DESC descr,
Sum(
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 SommaOre
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)