• This isn't working. Please tell me what I am missing...

    cast(DATEDIFF(hh, segstart, segstop)+':'+DATEDIFF(mm, segstart, segstop)+':'+DATEDIFF(ss, segstart, segstop)as nvarchar(25)) as a