Archives of the TeradataForum

Message Posted: Thu, 01 Nov 2007 @ 14:19:42 GMT

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

Etienne,

Have you thought of using a number some thing like '30010101' that may replace that null using a coalesce while you load? Now you exactly know what partition you are ending up with and the update statement will work okay too. Just a thought.

Thanks

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