>Yes it is supposed to be tree-like when done per my example (with the indents).

I do not know enough about sql server - but I think this is a step in the right direction (you need to copy and paste the link) http://msdn.microsoft.com/en-us/library/aa172799(SQL.80).aspx