|
Archives of the TeradataForumMessage Posted: Fri, 09 Dec 2005 @ 18:43:09 GMT
Hi, I have the situation that needs to convert the one record into multiple records, for example I am getting employee and his 12 months salary information as one record wise, I need to insert these 12 months salary information as 12 records ( one record for each month) Data in source table: EMP_ID JAN_REV FEB_REV MAR_REV APR_REV MAY_REV JUN_REV JUL_REV AUG_REV ... 101 100 200 300 400 500 600 700 800 ... Data Should be in Target Table : EMP_ID MONTH_NO REVENUE 101 1 100 101 2 200 101 3 300 101 4 400 101 5 500 ... How do we archive in Teradata using SQL stmt/Query. Advance thanks for your help Thanks, CR
| ||||||||||||||||||||||||||||||||||||||||||||||||
| ||||||||||||||||||||||||||||||||||||||||||||||||
Copyright 2016 - All Rights Reserved | ||||||||||||||||||||||||||||||||||||||||||||||||
Last Modified: 15 Jun 2023 | ||||||||||||||||||||||||||||||||||||||||||||||||