Archives of the TeradataForum

Message Posted: Mon, 23 May 2011 @ 19:49:58 GMT

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

Hi James,

I'm not actually sure what you're trying to do but does this give you what you want ?

     SEL StartTime,cast(' ' as char(3)) as spacer1,
         ElapsedTime,
         UserName,
         NumOfActiveAmps,
         NumResultRows,cast(' ' as char(3)) as spacer2,
         AMPCPUTime
     FROM dbc.qrylog
     WHERE Date - cast(CollectTimeStamp as date) < 90
     AND AppID = 'WIREPORTSERVER'
     AND NumOfActiveAMPs >=1
     ORDER BY 3 DESC;

Cheers,

Dave

Ward Analytics Ltd - Information in motion (www.ward-analytics.com)

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