String Tokenizing and Tokens processing

  • 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.

Viewing 0 posts

You must be logged in to reply to this topic. Login to reply