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)
Copyright © dotNetHell.it 2002-2025
Running on Windows Server 2008 R2 Standard, SQL Server 2012 & ASP.NET 3.5