Thank you Isaac for your advice. I had a parent/child relationship for a solution to this application, our dba does not want any recursive functions running on the database. And now i'm trying to switch gears.
I feel you on the falling asleep part, it's time to go home. :)