Torna al Thread

SELECT T1.prv_code, DateDiff("h", (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 Differ FROM R5PROPERTYVALUES AS T1 GROUP BY T1.prv_code ;
Copyright © dotNetHell.it 2002-2025
Running on Windows Server 2008 R2 Standard, SQL Server 2012 & ASP.NET 3.5