Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Thu, 03 Jan 2008 @ 10:35:58 GMT

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

Subj:   Re: Finding previous value
From:   Krithiga


Sorry,it was a typo,the effective dates are different

Here is a sample scenario

     item_num  advc num     effective_date

     278051    550949        11/04/2007
     278051    550953        11/04/2007
     278051    550962        11/04/2007
     278051    519293        03/25/2007
     278051    519284        03/25/2007

I have a requirement where if user dynamically chooses the effective date,the previous effective date and its corresponding advc num must be chosen.

Eg: If user chooses effective_date as 11/04/2007 then the report must display the previous effective date for the same item 278051 with previous effective date as 03/25/2007 with its advc num as 519293 and I need to show even the current effective date with its current advc num. Cud anyone help me out.

Thanks & Regards


  <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: 28 Jun 2020