2 Replies Latest reply: May 6, 2011 8:44 AM by Ralph Graham RSS

    Loading the most up to date Account history

      Hello,

       

      I'm hoping this will be a relatively simple query. I have a large amount of data and I only want to load the most up to date information. Table 1 belows shows an example of what I currently have, and basically I only want the latest DateChange data to come across, which is shown in Table 2. It seems to be an easy concept however I can't think of what to do in the script.

       

      Thanks

       

      Table 1

       

      AccountNoDateChangeTariff
      AB12345605/02/06HE
      AB12345604/08/10E7
      CD12345602/01/03HE
      CD12345605/04/07E7
      CD12345608/09/09HE
      EF12345602/03/07HE
      GH12345602/05/08E7

       

      Table 2

       

      AccountNoDateChangeTariff
      AB12345604/08/10E7
      CD12345608/09/09HE
      EF12345602/03/07HE
      GH12345602/05/08E7