Archives of the TeradataForum

Message Posted: Fri, 18 May 2001 @ 19:22:03 GMT

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

Is the Current spool still accumulating? Thanks -- it is still in the select phase.

The result of the second query you suggested gave me the following results...

Sum(CurrentSpool) ((100*Average(CurrentSpool))/Maximum(CurrentSpool))

699225088 11

Does L,M,N allow NULL values (i.e. is there current specification NOT NULL) or default value(s) 0 for numeric and blank ' ' for CHAR? Also what is the cardinality of L,M,N combinations (how many expected unique combinations compared to base rows )?

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