Archives of the TeradataForum

Message Posted: Wed, 14 Dec 2005 @ 19:48:30 GMT

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

Have you tried to use the CASE_N statement and 'AND' the two conditions together for identifying a specific partition? You would have to identify every case (condition) for each partition you wanted, and then a default OTHER or UNKNNOWN partition if you do not account for all possibilities.

mem

Michael E. McBride, MSCIS

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