Archives of the TeradataForum

Message Posted: Tue, 22 Apr 2008 @ 14:54:39 GMT

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

<-- Anonymously Posted: Tue, 22 Apr 2008 10:34 -->

Hi,

Hope this helps,

     UPDATE CI
        from (select * from
     FORECAST_PLAN FP ) as temp
     SET CURRENT_PERIOD_ID = temp.IMPORT_PERIOD_ID,
     CURRENT_EFFECTIVE_PERIOD_ID =
     temp.IMPORT_PERIOD_ID WHERE ci.NATIVE_PK = temp.inSKU_ID ;

Regards

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