I have a table with time snapshots about servers uptime since last reboot:
As you see timesnapshots are locked up in a string.
I need to determine if there was a downtime event - next timesnapshot < then previous
Like in case with deviceid=100 - 23 < 12345 it means server was down. I need to capture this event.
I am able to tokenize a string into a table of records:
Oracle PL/SQL has arrays, I can do it relatively easy there. T-SQL has no arrays...
Could you suggest how to process them?
I can process string in Perl, but I'd like, if possible, do all processing in the database.