Archives of the TeradataForum

Message Posted: Wed, 17 Oct 2007 @ 08:50:28 GMT

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

Hi Kamin,

Generally speaking, I think you can only perform "constant" expressions in the VALUES clause of an INSERT statement - that is, scalar expressions on constants? I think you have to use an INSERT ... SELECT to perform any kind of aggregate or ordered analytic function, which would make it very hard to generate surrogates during the load. Dave's suggestions are the only things I could think of. You may also be able to do it by writing a scalar UDF, but that seems like a lot of work ...

- Chris

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