You're right, I was unknowingly referring to MADs. I would hope to update daily. Nested Sets sound right on. In reference to my question at http://www.sqlservercentral.com/Forums/Topic1765709-373-1.aspx, how would using nested...

I am projecting often to be at least 3000/year and up to at least 30,000/year. I have yet to design this update mechanism. I have trouble thinking in terms of...