Archives of the TeradataForum

Message Posted: Mon, 02 Aug 1999 @ 21:29:36 GMT

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

I don't know a way to do this. Also, be aware that a COUNT(*) generates a value of '1' irrespective of the number returned.

The solution is normally to run the query as a count and to put that value in the table after the work has been performed.

Paul Johnson.

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