SELECT top 100 max(DATEDIFF(second,TimeStart,Timeend)) ,q.c_NAME FROM ReportServer..Catalog c,ReportServer..ExecutionLog e,shq_srv.enjoy_shq.dbo.tbc_rpt_format q WHERE TimeStart>'2013-5-17' and itemid=e.reportid AND q.c_guid=name group by q.c_NAME order by max(DATEDIFF(second,TimeStart,Timeend)) desc