Hello,
I have a table with 1.3+ million records. The table houses account numbers (they can exist more than once), a Field_Data_ID field (is incremental and does not repeat...greatest number is most recent addition), a Description field, START_DT and END_DT both in YYYYMMDD format.
My challenge is to find each Field_Data_ID that exists for each unique account number. Once that is done, I need to find where the corresponding START_DT and END_DT overlap or otherwise conflict.
The first part was a simple sort. I want to make an additional column that will say UDF1, UDF2, UDF3, etc. based on the FIELD_DATA_ID hierarchy of each unique account number.
I have no idea where to begin and there are too many records for excel! HELP!...please.
I have a table with 1.3+ million records. The table houses account numbers (they can exist more than once), a Field_Data_ID field (is incremental and does not repeat...greatest number is most recent addition), a Description field, START_DT and END_DT both in YYYYMMDD format.
My challenge is to find each Field_Data_ID that exists for each unique account number. Once that is done, I need to find where the corresponding START_DT and END_DT overlap or otherwise conflict.
The first part was a simple sort. I want to make an additional column that will say UDF1, UDF2, UDF3, etc. based on the FIELD_DATA_ID hierarchy of each unique account number.
I have no idea where to begin and there are too many records for excel! HELP!...please.