Archives of the TeradataForum

Message Posted: Tue, 19 Feb 2008 @ 10:14:59 GMT

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

We have a table with:

     Product  Expanded_product

        011X  0110
        0111  0111

Products ending in X needs to be duplicated/expanded:

     Product  Expanded_product

        011X  0110
        0111  0111
        011X  0112
        011X  0113
        011X  0114
        .
        .
        011X  0119

I have pulled the �%%%X� products into a work table but isn�t there a way to load the 2-9 versions into the base table without running a separate set of inserts for each value?

The table only has 2,000 rows.

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