String Tokenizing and Tokens processing

• pshvets

  SSCommitted

  Points: 1850

  More actions

  March 17, 2009 at 10:22 am

  #207023

  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.