��(b��o)������(w��)�����Џ�(qi��ng)�����־�Ĺ�������־��ӛ��˲�ԃ�^�Ĉ�(b��o)����һЩ��Ϣ������ӛ䛔�(sh��)���\(y��n)�Еr(sh��)�g����(b��o)���ą���(sh��)�ȣ���ͨ�^�_ʼ���ںͽY(ji��)�����ڵ��\(y��n)�㣬����֪���Ă�(g��)��(b��o)����������ԃ?n��i)��£?/font>
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
ȡ��������(b��o)����top100
�Ӻ��� 
�l(f��)����
Post By��2013/5/20 11:07:01
