|
|
Archives of the TeradataForum
Message Posted: Wed, 31 Aug 2005 @ 08:12:38 GMT
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
| |