Archives of the TeradataForum
Message Posted: Mon, 23 May 2011 @ 17:57:40 GMT
| Subj: || || Format of output |
| From: || || JAMES PARK |
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.
SEL StartTime ElapsedTime, UserName, NumOfActiveAmps, NumResultRows, AMPCPUTime
WHERE Date - cast(CollectTimeStamp as date) < 90
AND AppID = 'WIREPORTSERVER'
AND NumOfActiveAMPs >=1
ORDER BY 3 DESC;