SQL - Convertir Horas a Decimal

[Libras]

Código SQL:

CREATE TABLE #prueba 
(
hora datetime ,
hora2 datetime ,
horadif AS CAST((hora2 - hora) AS TIME (0) ),
Horatotal AS datediff(mi, hora, hora2) / 60.0
) 
 
INSERT INTO #prueba (hora,hora2) VALUES (GETDATE(),dateadd(mi,30,(DATEADD(hh,2,getdate()))))
SELECT * FROM #prueba
 

:)

aqui dejo el link de donde tome la idea ;)

http://stackoverflow.com/questions/1...ith-an-integer