Thanks for the article, I always enjoy exploring new ways to tackle persistent challenges.

I particularly like that it handles variable length run_duration values.

Is there a performance gain using...

Take Jeff Moden's advice here:

"For better, quicker answers, click on the following... http://www.sqlservercentral.com/articles/Best+Practices/61537/"

Thank you, that is a HUGE help and gets me on the right track.

At this point I either need to rethink my approach and handle the conversion on the applications...

You Rock! Thank you!

FORCE ORDER was exactly what was needed (still need to gauge performance impacts and such but the error is gone)

SELECT iObjectId

...