Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 31 Aug 2005 @ 08:12:38 GMT


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


Subj:   Re: Row to Column Function
 
From:   Le, Hien

Michael Larkins wrote:

  Oops, after I hit SEND, I realized that there would still be multiple rows for each department in the derived table. So, this is more along the lines of what you need:  


If I have about 100 of job names (for one employee) to convert into a string (tab delimited: empl_i job_name1 ... job_name100) column and the job number is different between employees and the source table (empl_i, job_name) will be updated from time to time (ie larger number or smaller number), then what is the best way to do this coz I don't want to change the code every time the table is updated


Thanks

Hien



     
  <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