>>Use SUM (CAST(Temp.SecondValue as DECIMAL(22,2)) /3600)
>
>The CAST had to be done inside the SQL and not on the final calculation. Otherwise, we will not have the precision at first.
Did you see my updated message? CAST the value to SUM first, then divide by 3600.
If it's not broken, fix it until it is.
My Blog