������������Џ������־�Ĺ��ܣ���־��ӛ��˲�ԃ�^�Ĉ����һЩ��Ϣ������ӛ䛔����\�Еr�g������ą����ȣ���ͨ�^�_ʼ���ںͽY�����ڵ��\�㣬����֪���Ă������������ԃ���£�

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

ȡ�����������top100