MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.
declare @test as int set @test = 87610 -- i think this is millisecond but the output should be 24:20:10 NOT 00:20:10 select convert(varchar(8),dateadd(ss,isnull((@test),0),'00:00:00'),108) Avg_Response_Time
|TSQL convert date to string||4||39|
|Compare a numeric value to a varchar w/o getting an error||4||21|
|How to use spatial data types in SQL Server Database project||2||24|
|question about results where i dont have a match||3||23|