SQL to detect when a record was entered
Date: Thu, 21 May 2009 06:17:14 -0700 (PDT)
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
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