Archives of the TeradataForum
Message Posted: Fri, 12 Jan 2007 @ 13:11:41 GMT
| Subj: || || Re: ORDER BY in INSERT SELECT to GENERATE Sequence |
| From: || || Michael Larkins |
I would try the Row_number OLAP function in the select. It will order the values and assign the sequential number. I have never tried these
in an insert select - my guess is that it would work because the sort is internal to the function and works with a derived table.
Certified Teradata Master
Certified Teradata SQL Instructor