declare @sql varchar(20)
set @sql='37:02:10'
--test--
SELECT substring(@sql,0,charindex(':',left(@sql,3)))
select cast(substring(@sql,0,charindex(':',left(@sql,3))) as int)*3600
+cast(substring(right(@sql,5),0,charindex(':',right(@sql,5))) as int)*60
+substring(right(@sql,5),charindex(':',right(@sql,5))+1,len(right(@sql,5))-charindex(':',right(@sql,5)))
--end test ----
declare @i int
set @i=133330
select cast(@i/3600 as varchar)
+':'+
case when len(@i%3600/60)=1 then '0'+cast(@i%3600/60 as varchar) else cast(@i%60/60 as varchar) end
+':'+
case when len(@i%60)=1 then '0'+cast(@i%60 as varchar) else cast(@i%60 as varc