Archives of the TeradataForum

Message Posted: Tue, 19 Feb 2008 @ 21:54:15 GMT

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

All,

Does Teradata have a function which I can use to Pivot data across - Convert multiple rows into multiple columns!!

Here is an Example:

If I have a table which has an Employee Id and a table which has the Employee Ids and date associated to an employee.

     ***Employee Table*

     Employee Id  Employee Name
     12345        Joe Smith
     45678        Sue Mary


     ***Employee Date Table*

     Employee                    Sequence
     Id         Date Role         Number     Date
     12345      Start Date                   02/01/2000
     12345      Promotion Date      1        03/01/2000
     12345      Promotion Date      2        04/01/2000


     ***Expected Output*
                                          1^st         2^nd
     Employee   Employee    Start        Promotion    Promotion
     Id         Name        Date         Date         Date
     12345      Joe Smith   02/01/2000   03/01/2000   04/01/2000

Thanks!

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