Torna al Thread

SELECT YEAR(T1.EVT_TARGET) AS anno, MONTH(T1.EVT_TARGET) AS mese, T1.EVT_JOBTYPE, T2.prv_code, DateDiff(hh, (select T3.prv_dvalue from R5PROPERTYVALUES AS T3 where (T3.PRV_PROPERTY = 'UTNCIN' AND T3.prv_code = T2.prv_code)), (select T4.prv_dvalue from R5PROPERTYVALUES AS T4 where (T4.PRV_PROPERTY = 'UTNCOUT' AND T4.prv_code = T2.prv_code)) ) AS Differ FROM R5EVENTS AS T1 INNER JOIN dbo.R5PROPERTYVALUES AS T2 ON T2.PRV_CODE = T1.EVT_CODE GROUP BY YEAR(T1.EVT_TARGET), MONTH(T1.EVT_TARGET), T2.prv_code, T1.EVT_JOBTYPE
Copyright © dotNetHell.it 2002-2025
Running on Windows Server 2008 R2 Standard, SQL Server 2012 & ASP.NET 3.5