Sip, eslo que estoy hacieno pero ya me atore para sacar los segundos y milisegundos......
Código:
SELECT CASE WHEN DATEDIFF(hh, '2008-10-03 14:44:53.850', '2008-10-03 14:46:01.650') >= 1
THEN (DATEDIFF(ms,'2008-10-03 14:44:53.850', '2008-10-03 14:46:01.650')/3600000)
ELSE DATEDIFF(hh,'2008-10-03 14:44:53.850', '2008-10-03 14:46:01.650') END AS Horas,
CASE WHEN DATEDIFF(mi,'2008-10-03 14:44:53.850', '2008-10-03 14:46:01.650') >= 60
THEN ((DATEDIFF(ms,'2008-10-03 14:44:53.850', '2008-10-03 14:46:01.650') - 3600000)/60000)
ELSE (DATEDIFF(ms,'2008-10-03 14:44:53.850', '2008-10-03 14:46:01.650')/60000) END Minutos,
DATEDIFF(s,'2008-10-03 14:44:53.850', '2008-10-03 14:46:01.650') AS Segundos,
DATEDIFF(ms,'2008-10-03 14:44:53.850', '2008-10-03 14:46:01.650') AS Segundos