 |
 |
Archives of the TeradataForum
Message Posted: Thu, 11 Jun 2009 @ 15:08:57 GMT
| Subj: | | Re: Need to split column value into Diff Rows |
| |
| From: | | Michael Larkins |
I would use RECURSIVE processing to do this. A couple of Partner's conferences ago I had a presentation that did this exact thing to build
the derived table and then dumped them into the production table. It did not matter how many of the different variables there were because I
could determine the end by using the CHARACTER function to the length.
Regards,
Michael Larkins
Certified Teradata Master
Certified Teradata SQL Instructor
| |
