Archives of the TeradataForum

Message Posted: Mon, 23 May 2011 @ 17:57:40 GMT

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

How can I put some space between StartTime and ElapsedTime and between NumResultRows and AMPCPUTime in the output?

I tried different ways but couldn't figure that out.

Thanks,

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

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