Archives of the TeradataForum

Message Posted: Tue, 24 May 2011 @ 08:54:04 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

HI,

Or Else a simple one

     SEL StartTime, '    ' , ElapsedTime, UserName, NumOfActiveAmps,
     NumResultRows,'   ',
     AMPCPUTime
     FROM dbc.qrylog
     WHERE
     Date - cast(CollectTimeStamp as date) < 90 ................

Thanks

Machha

	<Prev	Next>		<<First	<Prev	Next>	Last>>