You're problem doesn't appear to be hierarchical in nature. For that reason, I'd prefer to not dilute the discussion on this thread to something off topic. Would you repost your question on one of the T-SQL related forums on this site, please. I'm sure a ton of people would be happy to help especially if you take the time to read the first link in my signature line below.
Thanks.
--Jeff Moden
Change is inevitable... Change for the better is not.