SQL to detect when a record was entered
From: Alt255 <alt255.2005_at_gmail.com>
Date: Thu, 21 May 2009 06:17:14 -0700 (PDT)
Message-ID: <7d813a03-61b8-46de-9d62-64aa026f78cb_at_f16g2000vbf.googlegroups.com>
Hello all, this is a puzzle thats been bugging me for sometime, and now it looks like I *have* to build something.
Date: Thu, 21 May 2009 06:17:14 -0700 (PDT)
Message-ID: <7d813a03-61b8-46de-9d62-64aa026f78cb_at_f16g2000vbf.googlegroups.com>
Hello all, this is a puzzle thats been bugging me for sometime, and now it looks like I *have* to build something.
I would like to know when a code number changed for an account in a
delta table.
The table contains the account number, several code numbers, a row
insert date and basically looks like this
DPLH_ROW_EFFCT_DTE DPLH_PLAN_NUM USERID_NAM DPLH_SIOB_CDE
DPLH_SLIQ_CDE
4/15/2009 164328 LACSOA1 99 99 4/30/2009 164328 LACSOA1 5 99 5/19/2009 164328 LACSOA1 101 105
There are many other fields, so records could be added unrelated to the code numbers I'm interested in. So my challenged is to identify any DPLH_PLAN_NUMs that have had their DPLH_SIOB_CDE or SLIQ_CDE changed. It seems I need to compare the last record to the second last record. Is this even possible? Received on Thu May 21 2009 - 08:17:14 CDT