If you by chance are using sql 2008...this works great for this format hh:mi:ss:mmm

of course sql 2005 is more complicated

select convert(char(12),(convert(time,Dateadd(ms,Duration,0),114))) as 'Duration (hh:mi:ss:mmm)'