Archives of the TeradataForum
Message Posted: Tue, 19 Feb 2008 @ 10:14:59 GMT
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.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|