Thanks in advance for all of your time and help. It is greatly appreciated!!
First, I need to find the record where -
METRIC_INTERNAL_NAME = 'LOGIN' AND DATA_MNEMONIC_ID = 'DEP'
Then collect all records until
METRIC_INTERNAL_NAME = 'LOGOUT' AND DATA_MNEMONIC_ID = 'TIMEOUT'
then loop through and find the next records where the conditions above are true.
I was thinking (but what do I know) of writing each group of records to a temp table.
First, I need to find the record where -
METRIC_INTERNAL_NAME = 'LOGIN' AND DATA_MNEMONIC_ID = 'DEP'
Then collect all records until
METRIC_INTERNAL_NAME = 'LOGOUT' AND DATA_MNEMONIC_ID = 'TIMEOUT'
then loop through and find the next records where the conditions above are true.
I was thinking (but what do I know) of writing each group of records to a temp table.