Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Thu, 11 Jun 2009 @ 15:08:57 GMT


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


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



     
  <Prev Next>   <<First <Prev Next> Last>>  
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023