No problem, Michael.  But I am curious what the OP actually wants... it looks like he's trying to display the tree for a current drill down into a set of...

Um... what do you mean by "manually eiditing the table"? 

Dollars to donuts the views are aggragate views that either return to many columns or might even have views of views or UDF's.

Also, any of these tables have a primary...

Don't change anything that's owned by the system... period.

Make a copy of sp_SpaceUsed under a different name and then make all the changes you want.

Heh... 5 rows for 2 users generates 1,460 rows in the #Days table to start with.  Wonder what's going to happen when you have 10,000 rows for 100 users?

I'm thinking that DTS is going to be your only way out if you don't want to or can't use a command prompt of xp_CmdShell.

If you had a really cool...

Peter, any way you guys can suppress the double spacing?  And, which editor are you using (I like the colors)

Uh-huh... What is that that you would like to do for the following?

ID Name   ParentID Level

1  Root   null     1

2  Trunk  1        2

3  Branch 2        3

4  Leaf   3        4

5 ...

Why are you storing such data in your database?  Can't you get the source info into a little better shape, first?

The best performance will come from BULK INSERT followed closely by BCP in most cases.  But "What is Best" is in the eyes of the beholder... If you need the...

No... not more VB like... more mathematical like

Sure would be nice if you posted the URL of the article you read...

Sounds like an interesting article... do you have the link?  I'd like to take a peek...

Thanks, Tracey.

Heh... ok... no flaming   But I'll just bet you'll never again let another vendor touch your DB's without making a full backup, huh?...

Not sure if this can be done in Analysis Services because I don't use it  

In the T-SQL side of the house, we...