Archives of the TeradataForum

Message Posted: Thu, 08 Jun 2006 @ 14:43:38 GMT

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

I think there is a (release dependent?) limit for the number of WHERE clauses in CASE. I don't remember now what it is but I think it can be as low as 32. So, this solution might need some tweaking: assuming the limit is 32, create 8 temp tables with PK+32 columns, populate them and then perform one big INSERT ... SELECT with the 8-fold join on PK. Sounds doable?

Regards,

Victor

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