Hello all,
I have a table with time snapshots about servers uptime since last reboot:
deviceid value
100 3456:12345:23:98904:
200 458458:567890346:232323:128586:
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:
TokenID Token
1 3456
2 12345
3 23
4 98904
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.
Regards,
Pit.